How to change 2 decimal by default is excel ?
Posted on 2014-09-08
i have the CSV file with this following value
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.