| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a figure as cent (e.g. 0.015 displayed as 1.15)
I would like to format number expressed in Euro (same with Dollars) in cent.
e.g. instead of having "0.0123 ‚¬" I would like to see "1.23 ct" Using percentage symbol I get the right figures but with the wrong symbol: format: "0.00 %" -- figure is displayed as "1.23 %" Is it possible to change or remove the %symbol ? Is there another solution ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format a figure as cent (e.g. 0.015 displayed as 1.15)
This is based on the standard monetary format.
Go to Format CellsNumberCustom and paste this; _-* #,##0.00 ct_-;-* #,##0.00 ct_-;_-* "-"?? ct_-;_-@_- "JMiB55" wrote: I would like to format number expressed in Euro (same with Dollars) in cent. e.g. instead of having "0.0123 ‚¬" I would like to see "1.23 ct" Using percentage symbol I get the right figures but with the wrong symbol: format: "0.00 %" -- figure is displayed as "1.23 %" Is it possible to change or remove the %symbol ? Is there another solution ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i format the text displayed in a drop down menu? | Excel Discussion (Misc queries) | |||
| format decimals displayed based on results | Excel Discussion (Misc queries) | |||
| format a six figure number to a time. | Excel Discussion (Misc queries) | |||
| HOW DO I EXCLUDED A FIGURE FROM A CONDITIONAL FORMAT???? | Excel Worksheet Functions | |||
| Displayed number format | Excel Worksheet Functions | |||
Linear Mode
