Dots to Commas

[doublej41]

Hi All

In my office Excel is set to use commas as the decimal separator, however some software we use for recording data outputs with a dot as the decimal separator.

Is there a method by way of a formula that will allow me to change the dot to a comma? Until now I have been changing it using the Find and Replace function, however this is now a protected workbook on our file server and this function is no longer allowed.

Thanks for all suggestions

Jonathan

 

[pushkardey]

=substitute(A1,".",",")

 

[doublej41]

Many thanks pushkardey - does the job!