Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
rwtuning
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default how do I custom format .0040 to show as 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" 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
JimMay
 
Posts: n/a
Default how do I custom format .0040 to show as 40 ?

=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.


  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme
 
Posts: n/a
Default how do I custom format .0040 to show as 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" 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom percent format needed Will Fleenor Excel Worksheet Functions 1 June 29th 05 02:57 AM
Cell will not format numbers correctly for a 13 digit custom barc. Laudan Excel Worksheet Functions 4 April 11th 05 08:13 PM
Custom format that shows blank cell if another cell is empty Zdenek Moravec Excel Discussion (Misc queries) 1 March 25th 05 11:45 AM
How do I format a cell for a custom part number? PJ Excel Discussion (Misc queries) 4 March 3rd 05 03:57 AM
Custom Format for ¢ Stephen POWELL Excel Discussion (Misc queries) 0 February 25th 05 07:11 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"