Cell Not Formatting correctly.

  • Thread starter Thread starter jrdavis
  • Start date Start date
J

jrdavis

Okay, here is my issue. I formatted a column for phone number - the
only way the phone number will show formatted is if I double click in
the cell or if I click on the cell and press F2.

What's going on? I tried to Edit|Clear|Formats but that didn't work
either.

Any suggestions? The list I need to format is over a few thousand
rows.

Thanks for the help!
 
I know what you mean.......some cells seem to get "stuck" in the formatting
cycle.......what I would do is to just left-click on some clean un-formatted
cell, then left click on the little formatting paintbursh up in the tool
bar, then left click on the cell in question......sometimes this will "break
the loop" and then you can just re-format it to whatever you want, and go on
from there.......

Vaya con Dios,
Chuck, CABGx3
 
If the cell(s) were formatted as text originally, then changing the cell to
phone number won't help. Hitting F2, then enter tells excel you're reentering
the data, so it sees it as numeric and then it can format it as a phone number.

Another way to "reenter" the data is to make a mass change.

If you can pick out a digit that's used a lot (maybe 1) and just
edit|replace 1 with 1 (2 with 2, etc)

excel will respect the phone number format.

(If you're lucky, you won't need a lot of mass changes!)
 
Back
Top