Replace Decimal points with commas in spread sheet?

[C.j.]

I uploaded a spreadsheet and it replaced the majority of the commas to decimal points such as 1.000 instead of 1,000. anyone know how I can change all of these at once?

[arlu1201]

Are there any other commas that should not be changed back to decimal points?

In that case, you can do a normal find replace.

[C.j.]

some are correct as commas and some are decimals, they should all be commas

[arlu1201]

Have you tried a find-replace?

[crazydirthead]

Hey c.j.,

If you open your excel and push ctrl+F then push the replace tab in the popup dialog box. In the "Find what:" box put in what you want replaced (the decimal), and then in the "Replace with:" box, put what you want all of them to be replaced with (the comma). Capture1.PNG Should look something like that. Then you can push replace to do it one at a time and monitor, or if you just push replace all, every decimal on that sheet will be replaced with a comma automatically. Hope this helps.

[ben_hensel]

So in French the comma is used instead of the period to mark the decimal point. That is just a piece of trivia I've happened to pick up in my life. I don't know about other languages but I happen to know that excel uses the comma as the decimal separator if you've set the language to French.

Do you want 1,000 to be "one-point-zero-zero-zero" or "one thousand"?

Because if you use ctrl-F then it will become "one thousand". It might change it to text too, depending of formatting? Not sure, when I tried it it remained a number but that wasn't really exhaustive testing.

Otherwise... read this.