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

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

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" <[email protected]> wrote in message
news:[email protected]...
> I'm using Excel 2003. I want to custom number format .0040 to show as 40,
> without actually changing it to 40.

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


"Bernard Liengme" <[email protected]> wrote in message
news:[email protected]:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > I'm using Excel 2003. I want to custom number format .0040 to show as 40,
> > without actually changing it to 40.

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" <[email protected]> wrote in message
news:DUHkg.41371$fG3.7041@dukeread09...
> =TEXT((A1*10000),"00")
> Comes to mine,....
>
>
> "Bernard Liengme" <[email protected]> wrote in message
> news:[email protected]:
>
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > I'm using Excel 2003. I want to custom number format .0040 to show as
>> > 40,
>> > without actually changing it to 40.
>