SOS. Can anyone help me to resolve a really minor issue that took me the whole day.

[EugeneOz]

Hi Everyone,

Could anyone help me please.

I have converted data into excel file from accounting software - SAP. The figures I have are all in text and are 535.627,44 or 3.525.038,65 format. I have these dots and comma issue. Excel does not understand that it is numbers. Can anyone help me to convert these data into numbers.

Thanks in advance.

Regards,
Eugene

 

[Peter_SSs]

Assuming that your normal number format is "," for thousand separator and "." as decimal indicator try this manual method (could be done by macro)

Select the column
Find/Replace (Ctrl+H) -> Find what: . -> Replace with: leave blank -> Replace All
Find/Replace (Ctrl+H) -> Find what: , -> Replace with: . -> Replace All

 

[EugeneOz]

Assuming that your normal number format is "," for thousand separator and "." as decimal indicator try this manual method (could be done by macro)

Select the column
Find/Replace (Ctrl+H) -> Find what: . -> Replace with: leave blank -> Replace All
Find/Replace (Ctrl+H) -> Find what: , -> Replace with: . -> Replace All

Thanks mate, I knew it should be simple. have a good day

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.