How to get the correct numeric values in excel? - TechRepublic
Question
May 27, 2010 at 02:19 AM
tatajimullapudi

How to get the correct numeric values in excel?

by tatajimullapudi . Updated 16 years, 1 month ago

Whenever i’m trying to enter a numeric value in the excel sheet, i am getting a problem.
let us say, i am entering the value 2 in a cell and after i come out of the cell, the value is displaying as 0.02. I have tried by choosing General, Number and Text options from the Format Cells window, but no luck.
Even, if i change the number of digits to display as zero, no luck.

This discussion is locked

All Comments