Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
It worked!
Thank you so much, Tom! You don't know how much I
appreciate this! You saved me hours and hours of work. Thanks again and I hope you have a great weekend! Nikki -----Original Message----- Let me correct myself - I don't believe I correctly interpreted your requirement - and I mispoke about 11111. Try this format [<100000]00000-"0000";00000-0000 for 11111 it does display 11111-0000 -- Regards, Tom Ogilvy "Nikki" wrote in message ... I just tried that and it doesn't look like it did anything... Any other ideas? -----Original Message----- Select the column then: format = Cells = Number Tab, go to Custom [<100000]00000;00000-0000 I believe this will do what you want. -- Regards, Tom Ogilvy "Nikki" wrote in message ... I've got a list of about 1500 zip codes in my worksheet. Unfortunately, they are not all formatted the same way. I want them all to have the zip code plus 4 digits format (00000-0000). But, whenever I choose that in the format cells dialog box, it automatically changes the zip code that were only 5 digits to have four leading zeros. Example, from 11111 to 00001-1111, instead of 11111- 0000. I want it to add the zeros to the end, not the beginning. Any idea on how I can get it to work this way? I figured I'd be able to program it to work that way, but I'm not familiar with the programming part, so I don't even know where to start. Oh, and I'm using Excel 2003... Thanks! . . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
It worked!
Thanks for the enthusiastic response and sorry for the initial "Bum Steer".
-- Regards, Tom Ogilvy "Nikki" wrote in message ... Thank you so much, Tom! You don't know how much I appreciate this! You saved me hours and hours of work. Thanks again and I hope you have a great weekend! Nikki -----Original Message----- Let me correct myself - I don't believe I correctly interpreted your requirement - and I mispoke about 11111. Try this format [<100000]00000-"0000";00000-0000 for 11111 it does display 11111-0000 -- Regards, Tom Ogilvy "Nikki" wrote in message ... I just tried that and it doesn't look like it did anything... Any other ideas? -----Original Message----- Select the column then: format = Cells = Number Tab, go to Custom [<100000]00000;00000-0000 I believe this will do what you want. -- Regards, Tom Ogilvy "Nikki" wrote in message ... I've got a list of about 1500 zip codes in my worksheet. Unfortunately, they are not all formatted the same way. I want them all to have the zip code plus 4 digits format (00000-0000). But, whenever I choose that in the format cells dialog box, it automatically changes the zip code that were only 5 digits to have four leading zeros. Example, from 11111 to 00001-1111, instead of 11111- 0000. I want it to add the zeros to the end, not the beginning. Any idea on how I can get it to work this way? I figured I'd be able to program it to work that way, but I'm not familiar with the programming part, so I don't even know where to start. Oh, and I'm using Excel 2003... Thanks! . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The reply worked, but I still need help.... | Excel Worksheet Functions | |||
Most hours worked | New Users to Excel | |||
It Worked!!! :-) | Excel Discussion (Misc queries) | |||
Hours worked | Excel Worksheet Functions | |||
It worked! | Excel Programming |