replace "," with a "."

W

wind_energy

I have over 900 columns and they were sent to me from an associate. I need to
make 201,354,231 into 201.354 and so on. Remember I have a whole column of
these. Is there a way to simplify this process?
 
B

Bob Phillips

Type 1,000,000 into a spare cell and copy it

Select all the numbers to change
Goto Edit>PasteSpecial and select Values
OK

Format the cells to required format.

clear the spare cell.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

I did, thanks.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top