How format cells ?

F

Fantom

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
 
G

Gord Dibben

Fantom

Format>Cells>Number>Custom

#,##0.00"z then hit ALT + 0179(on numpad) then add another "


Gord Dibben Excel MVP
 
G

Gord Dibben

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 Format>Cells>Number>Custom 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
 
Top