The Excel in my computer is in spanish, it doesn’t recognize the decimal point a a period “.” since in spanish the decimal point is a comma “,” .
I have a list of 500 numbers all with periods as decimal points but my excel doesn’t recognize them as numbers, instead of changing 500 period to commas, what can I do? the excel can’t change into the english format (or I haven’t found out how to do that).
If anyone can help me it would be very much appreciated. !!!
how about you use a word processor to replace all the periods with commas?
Heck, you shouldn’t even need a word processor. You can do it right in Excel. Search and replace. If necessary format the cells as text first.