Forum Discussion

Domo_Casati's avatar
Domo_Casati
Copper Contributor
May 24, 2022

exel spreadsheet populated with full stops for financial values, can I change the stops to commas?

I have populated an entire spreadsheet with financial values expressed in points rather than commas. How can I fix this as the amounts do not respond to the addition sign.

  • Domo_Casati 

    If your system is set to use comma as decimal separator, use the Replace dialog (Ctrl+H) to replace all points (dots/full stops) with commas.

Resources