how do I custom format .0040 to show as 40 ?

[Guest]

I'm using Excel 2003. I want to custom number format .0040 to show as 40,
without actually changing it to 40.

 

[Bernard Liengme]

The long silence confirms by suspension that what you want cannot be done,
best wishes

 

[JimMay]

=TEXT((A1*10000),"00")
Comes to mine,....

The long silence confirms by suspension that what you want cannot be done,
best wishes

 

[Bernard Liengme]

No! The OP wanted to enter 0.0040 and have 40 displayed in the same cell.
If you are to use anther cell why bother with Text, a simple =A1*1000 would
do!
best wishes