Excel - fixing formatting
Thank you "bj"
This is perfect.
"bj" wrote:
in cell AK1 enter a 1
copy AK1
select A1:AJ5136
paste special-mutitply
with A1:Aj5136 selected
formatcellnumberspecialtelephone number
"sos-DC" wrote:
I have a spreadsheet that is
Columns run A-AJ
Rows run 1 through 5136 (yes, five thousand + rows)
Someone else created it (database) and EVERY cell begins with what looks
like an apostrophe, but I cannot do a global search/replace to get rid of
them as I ususally do. Deleting the apostrophe cell by cell is NOT an option.
All the cells also have a small green triangle in the upper left-hand
corner. I am trying to change the phone number format from
0000000000
to
000-000-0000
I did a format change, but it will not show correctly unless I can remove
the apostrophes.
|