pc-confused

Posts: n/a

zip+4 format

What formula do i use to enter zipcode as 9 numbers and get back in 5-4 format?
Example: enter 77773333 see in cell 77777-3333

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
Telephone number format	MarkT	Excel Discussion (Misc queries)	6	January 18th 05 10:39 PM
How do i change numbers in text format to number format?	Greg	New Users to Excel	1	December 14th 04 05:22 PM
copy conditional format as ACTUAL format	Dana Zulager	Excel Discussion (Misc queries)	7	December 7th 04 11:02 PM
Copying a conditional format	Meaux	Excel Worksheet Functions	2	November 29th 04 10:19 AM
When I select "format cells", the format dialog box does not disp.	Andy S.	Excel Worksheet Functions	2	November 23rd 04 03:49 AM

All times are GMT +1. The time now is 08:17 AM.

About Us

"It's about Microsoft Excel"