Changing the comma in the numbers? 355,500 into 35,5? How to do that?

[garfiola]

I have this value in the cells

355000 it means in fact 35.5 USD not 355000 USD

Can you tell me how to remove the zeros and move the comma?

for 35,5 usd can I use comma or fullstop? is it 35,5 or 35.5?

 

[braindiesel]

I'm not sure about the comma, but you could use rounding.
If cell A1 contains 355000
in cell B1 type
=A1/10000
That will yield 35.5

Does that help?

 

[Marc]

How about:

=SUBSTITUTE(A1/10000,".",",")