microsoft excel training - Comma to decimal point

Hi Tyrel,

If the cell is in text format, you may need to write a macro to convert all commas to decimal points and vice-versa.

If the cells/data are in number format, see below...

In Excel, go to Tools -> Options -> International tab. Under the 'Number handling' heading, check the decimal and thousands separator. If you untick the box below this ('use system separators'), you'll be able to edit the two boxes with the separator of your choice.

You may need to format the cell to be Number + Use 1000's separator + 2 decimal places.

Another reason may be your system may be set up with locale information for Germany (or any other country using Euros), which would mean your thousands seperator is a . and your decimal point is a comma. eg. 2.999,95

To check this in Windows, go to Start -> Settings -> Control Panel -> Regional and Language Options -> and ensure the correct country is selected.

Hope this helps. Thanks again for attending our Excel Advanced course.

Regards, Rich