Transforme strange numbers into currency.

[BlitzMX]

Hello

I have a big excell report file with strange numbers that are supposed to be currency values.

2281.88000000
218.58000000
589.00000000
245.85000000
113.18000000

How do i work on this?

Thank you
Best regards
Blitz

[reagan.kha]

Hi Blitz,

You can change the cell formatting to Accounting (Currency). This should take care of any rounding and add a currency symbol in front of you numbers.

Thanks,

[BlitzMX]

I tried
It doesn´t. Nothing happened when i change the cell format.
Maybe because it uses a dot(.) instead of a coma(,).
I´m in Europe, i think it makes a diference.
How do i deal with this? Maybe a macro somehow?

Thank you.

[Kevin UK]

Hi BlitzMX

Are the values text! Then Text to columns could be an option.

[jake.masters]

If the values are on the left side of the cell, they are stored as text and should be converted to numbers. I am guessing this is your issue due to the periods instead of commas.


This link should help you with some instruction.

http://support.microsoft.com/kb/291047

[jake.masters]

Alternatively, Ctrl + H will bring up find and replace, and replace the periods in the cells with commas. Excel should be able to understand that better.

[BlitzMX]

Alternatively, Ctrl + H will bring up find and replace, and replace the periods in the cells with commas. Excel should be able to understand that better.

hehe i loved your idea... unfortunetly values are in a report that i will receive every week, the idea is to work with thos numbers.
I have a "Input" sheet where i pas the entire report, other sheets show statistics from that one, wish meen i cannot change dot allways. (O maybe i can).
Is ther a formula that can take a number and treat it in a way to change it from "." to ","?

Thank you

[BlitzMX]

If the values are on the left side of the cell, they are stored as text and should be converted to numbers. I am guessing this is your issue due to the periods instead of commas.


This link should help you with some instruction.

http://support.microsoft.com/kb/291047

Thay are on the left indeed. I´ll see your link.
Thank you