actual number

[jtwork]

I have a number which when viewed with 7 digits reads as 0.0299664 but if i view with 4 digits on reads 0.0300

i want to be able to see the actual number not round up or down

is this possible?

[ChemistB]

The only easy way I know how to do this is, assuming your value is in cell A1, in the next cell use the formula =FLOOR(A1, 0.0001). There are other ways to manipulate it but no way that I know of to directly format Excel not to round to the digits displayed.

ChemistB

[MrShorty]

Excel, like a lot of computer programs, uses the IEEE double precision floating point standard for representing numbers. This means that the actual number in a cell is represented to 15 significant digits. So, in order to see the entire actual value that Excel is using, you need a format that will show 15 significant digits. Easiest format is probably scientific format 0.00000000000000E+0.

Recognize that the 15th digit is still "rounded"