How to change 2 decimal by default is excel ?

i have the CSV file with this following value

-99.80
-188.00
-16.50
19.00

But when I open this file in excel it is showing only one decimal places like this
-99.8  (One decimal )
-188   (No decimal )
-16.5   (No decimal )
18  (No decimal


In the advances option I have selected the check box "Automatically Insert a decimal place"  and the number of decimal places is 2.
But I need two decimal places irrespective of any number , how do I change this in excel ? if open any excel sheet it should show 2 decimal place by default.
Varshini SAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

the option to "Automatically insert a decimal place" will apply when a number is manually entered. It will not format an existing number when a file is opened.

If you want two decimal places with all your Excel file, open a new, empty workbook, select all cells and format them with two decimals. Then save this file as an XLTX (template) and use it to create new files. You can also save it as Book1.XLTX in the Excel template path (where exactly that is depends on your operating system and version) and new files will be created from this template automatically.

With all existing files you will need to format the cells manually once, then save.

cheers, teylyn
0
Varshini SAuthor Commented:
I am using office 365 . I could not open the XLTX file in this version.
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Office 365 is a licensing model and sales channel for MS Office. It means you pay a monthly subscription instead of paying once for a license that does not expire. You can license Office with a 365 subscription.

What you are referring to (I think) is Web Excel, or Excel online.  The features of the browser based Excel are only a subset of the desktop Excel. Install Excel on your desktop if you want to use all its features.

If you only use Excel in the browser, you will need to format the cells manually.
0
Varshini SAuthor Commented:
I am using desktop version. I have the same issue in office 2010
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
So what do you mean by "I am using office 365 . I could not open the XLTX file in this version." Please understand that I cannot see your screen. You need to describe what is happening and what you see.  Otherwise I don't know how to help.

When you open a CSV file, Excel will show the numbers in General format. This will show only as many decimals as required for the precision. Trailing zeros will not be shown. You must format the cells manually.

Select all cells by clicking above row 1 and to the left of column A. Then set the format to 2 decimals.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.