Large Data Base has Numbers that need to be separated by a "."

[pick44]

Geox Geoy Lat Long
253704650 713336950

They should be like this:
2537046.50 7133369.50

They are formatted "General".

[Olly]

1. Enter the value 100 in a spare cell.
2. Copy that cell.
3. Select the range of numbers to be changed.
4. Paste Special > Values & Divide
5. Format to suit.

[pick44]

Thank you. Worked