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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JimMay" wrote in message
news:DUHkg.41371$fG3.7041@dukeread09...
=TEXT((A1*10000),"00")
Comes to mine,....


"Bernard Liengme" wrote in message
:

The long silence confirms by suspension that what you want cannot be
done,
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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