Format won't change unless you double click the cell

  • Thread starter Thread starter jmatchus
  • Start date Start date
J

jmatchus

Hello!

Strange issue. . .I am having a problem with a particular column o
data in my sheet. It is the only column out of 7 that the format won'
change unless you double-click the cell and click off of it. Not good
I need the format to show up with leading zeros for a total of fiv
places. Some of the numbers are three digits and some are four.
used the zipcode and a custom format and when you check the format, i
is set to be that way. However the numbers still show up as they are.
I have tried a number of different things and nothing is working!!!
Has anyone seen this or have a suggestion?

Thanks a lot!
 
I forgot to mention that the data was copied from another spreadsheet
but all of the other data that was copied at the same time is fine wit
a format change. It is just that particular column. It also doesn'
matter what format I use, it still won't change without a double-click


Thanks
 
You are a genius! That worked like a champ! Don't really understand wh
I can't get the text formatting out but oh well!! Thanks
 
Back
Top