How to convert numbers with comma decimal sepatators?

  • Thread starter Thread starter Ian Bull
  • Start date Start date
I

Ian Bull

I have received a spreadsheet from Germany which has commas instead of
fullstops as the decimal separator.

Is it possible to convert these to standard fullstop separators?

Thank you & Regards
Ian Bull
 
Hi Ian

Excel should take care of this herself, using whatever separator defined in Wondows' controlpanel. So I guess the real and graver
problem is that the numbers aren't values, just plain text, which is unsuitable for calculations.

But try a Replace (edit menu) on a few cells and see if they convert. Maybe they do.
 
Try this...Go to tools, options, international. Then see
what symbol is being carried in the decimal seperator box
and thousand seperator box. If the reverse of what you
want, turn the "use system seperators off", then type a .
over the , in the decimal seperator box and a , over
the . in the thousand seperator box.
 
Back
Top