Zip Code formatting problem

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

Using Excel 2003. I am copying/pasting data from one excel spreadsheet to
another - each have name/address/zip code field. Here's the problem - I have
formatted the current spreadsheet to the zip code format for the entire zip
code column, but when I copy/paste the data from my other spreadsheet into
the current one, it is showing the zip code field as text formatted. I went
into the original spreadsheet and changed the formatting on that entire
column to be zip code prior to copy/paste into the new one. Why won't the
format change from text to zip code?
 
Using Excel 2003. I am copying/pasting data from one excel spreadsheet to
another - each have name/address/zip code field. Here's the problem - I have
formatted the current spreadsheet to the zip code format for the entire zip
code column, but when I copy/paste the data from my other spreadsheet into
the current one, it is showing the zip code field as text formatted. I went
into the original spreadsheet and changed the formatting on that entire
column to be zip code prior to copy/paste into the new one. Why won't the
format change from text to zip code?
Click to expand...

What was wrong with Fred's answer? (Posted about 1/2 hour before this
posting).
--ron
 
Ron, the OP has responded to Fred..This was posted before even Fred
responded...
 
Ron, the OP has responded to Fred..This was posted before even Fred
responded...
Click to expand...

Jacob, on my newsreader:

Thread 1:
Format Cells as zip code not working 12/2/2009 7:24 PM
Fred's Response 12/2/2009 7:29 PM
**SS Response 12/2/2009 8:16 PM

Thread 2:
Zip Code formatting problem 12/2/2009 7:56 PM

I see now that he has responded to Fred in the first thread, but that wasn't
there when I downloaded the messages, and his re-post in thread 2 was present.
--ron
 
Back
Top