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

R

rwtuning

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

Bernard Liengme

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

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
 
Top