hehe - The ones you have changed with a formula are now text, and the others are numeric.
To do what you want though, simply copy an empty cell, select your entire range of data
and do Edit / Paste Special / Add.
What did you do to the 4 digit ones to make them 5 digit, just out of interest. Just in
terms of was it adding a 0 at the end, or what?
--
Regards
Ken.................. Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
----
Attitude - A little thing that makes a BIG difference
----
"billrebels4" <billrebels4.vt8sz...excelforum-nospam.com> wrote in message
news:billrebels4.vt8sz...excelforum-nospam.com...
> Ken- Ok, it seems i am back to square one. I have taken all of my zip
> codes and turned them into 5 digit (22202).. I used a formula to take
> the last four digits off of all the zips that had it. I then copy and
> pasted special/values into a new column... now some of the zips line up
> on the left(the ones i changed with the formula and the ones that were
> already 5 digit line up on the right.)
> if i click on the value bar at the top of my screen and then press
> enter the cell contents will shift to the right.. do i need to do this
> for all of them or can i tell excel to do it automatically'?
>
> ---
> ~~ Message posted from
http://www.ExcelTip.com/> ~~ View and post usenet messages directly from
http://www.ExcelForum.com/>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003