formula bar

[mandopolis]

is there any way for the formula bar to contain zeros after the number in a cell after theyve been entered?? (e.g .200) it seems to always revert back to .2 thanx!!

 

[Mark W.]

To be precise... it contains 0.2 which is exactly how the value is stored by Excel. Don't confuse a value's formatting with its internal representation!
This message was edited by Mark W. on 2002-04-17 15:00

 

[Jack in the UK]

maybe a fix format the cell to X decimal pklaces and force excel to repot as such!

 

[mandopolis]

thaxs 4 the help!