| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom percent format needed | Excel Worksheet Functions | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| Custom Format for ¢ | Excel Discussion (Misc queries) | |||
Linear Mode
