excel training uk - Excel commas and decimal places

Try TOOLS > OPTIONS > INTERNATIONAL tab.
In the first part, tick or untick the box that says USE SYSTEM SEPARATORS.

this will give you access to specify what you want to use for separators.

Dear Eric

When I use Find Replace it seems to be working few things I want to clarify:

I hope you are not using the inverted commas (" "). Please only use the , and . in the find and replace respectively!!

Also may be try to select the group of cells which has got ,(commas) and then use this!!

Also please make sure that you don't put a tick on either the Match case or Match entire cell content

Even if the cells are text for any reason because of, (commas) they automatically should be converted to number.

If it still doesn't work then as long as the data is not sensitive you can send a copy of the file or part of the file to the following address as attachment:

forum AT stl-training.co.uk
(please replace the AT with @ symbol)

Also once you have submitted the relevant file please copy and paste that URL (Web Address) from the address bar and post it on the Forum so that we can have a look at it and hoipefully resolve this!!

Thank you for your time!!