Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How format cells ?
Hi
I want format money for example '12,35 zł' - i want to show this as '12.35 zł' How i may write fiormula to this work ? Fantom ps. Soory but my english is poor |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How format cells ?
Fantom
FormatCellsNumberCustom #,##0.00"z then hit ALT + 0179(on numpad) then add another " Gord Dibben Excel MVP On Tue, 22 Nov 2005 15:30:51 +0100, "Fantom" wrote: Hi I want format money for example '12,35 zł' - i want to show this as '12.35 zł' How i may write fiormula to this work ? Fantom ps. Soory but my english is poor |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How format cells ?
FormatCellsNumberCustom
#,##0.00"z then hit ALT + 0179(on numpad) then add another " But i dont sum this cells :( Fantom |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How format cells ?
Fantom
Not asking you to sum these cells. Try it again........... Select a cell with a number in it. Assume 123 When you are in the FormatCellsNumberCustom menu........ In the "Type" dialog box enter #,###.00"z then without leaving the box hold the ALT key down and type 0179 on the numpad(right-side of keyboard). You will see the superscript 3 appear after the z. After that, still in the box type another " You will see what's happening in "Sample" to the format of the number as you finish. Gord On Wed, 23 Nov 2005 08:15:42 +0100, "Fantom" wrote: #,##0.00"z then hit ALT + 0179(on numpad) then add another " But i dont sum this cells :( Fantom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) |