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

Fantom

Format>Cells>Number>Custom

#,##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"
<[email protected]> 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

> Format>Cells>Number>Custom
>
> #,##0.00"z then hit ALT + 0179(on numpad) then add another "

But i dont sum this cells

Fantom

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

On Wed, 23 Nov 2005 08:15:42 +0100, "Fantom"
<[email protected]> wrote:

>>
>>
>> #,##0.00"z then hit ALT + 0179(on numpad) then add another "
>
>But i dont sum this cells
>
>Fantom