Zip Code formatting problem

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

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
 
J

Jacob Skaria

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top