Posted to microsoft.public.excel.worksheet.functions

Ofelia

Posts: n/a

Zip codes that begin with a zero...

I have a zip code that begins with a zero. I try to format the cell and it
appears to work, but it does not show the zero in the formula bar. Then I'll
save it but when I reopen the worksheet it does not save it. Is there some
other way of doing this? Please Help!- Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Labels not printing zip codes	Michele	Excel Discussion (Misc queries)	1	December 6th 05 08:54 PM
Counting codes	cj21	Excel Discussion (Misc queries)	15	November 7th 05 03:03 PM
Changing codes	cj21	Excel Discussion (Misc queries)	3	September 2nd 05 03:08 PM
VBA Codes	smck	Excel Worksheet Functions	2	May 11th 05 10:03 AM
Excel doesn't sort zip codes properly	[email protected]	Excel Discussion (Misc queries)	4	February 4th 05 12:30 AM

All times are GMT +1. The time now is 05:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us