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
Bookmarks