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

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

How format cells ?
 

FormatCellsNumberCustom

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

But i dont sum this cells :(

Fantom

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