Converting to a Price

[Wildie16]

Hi

I am having difficulty with converting a number to a price. I get a price feed through from a supplier, and it comes through with values in the price column of:

1044
2133
34000
29000
7333
9333
10889
7000

and so on....

When I format the cell to be a number, it will either add decimal places to the end of the number (1044.00) or if I use (,) as a separator, it turns it in to 1,044.

However - I need the numbers to be:

10,44
21,33
340,00
290,00
73,33
93,33
108,89
70,00

I just cannot seem to get this to happen though!

Any ideas how to get it formatted correctly?

Regards

[Glenn Kennedy]

=A1/100

in column B. If you wish, then copy/paste values in column B and delete column A.

[AliGW]

For Excel or Office Works Calc?