Zip Code formatting problem

[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?

 

[Ron Rosenfeld]

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?

What was wrong with Fred's answer? (Posted about 1/2 hour before this
posting).
--ron

 

[Jacob Skaria]

Ron, the OP has responded to Fred..This was posted before even Fred
responded...

 

[Ron Rosenfeld]

Ron, the OP has responded to Fred..This was posted before even Fred
responded...

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