Menu

custom number format code using letters and numbers

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.worksheet.functions

[email protected] brad-c@iherb.com is offline

brad-c@iherb.com is offline

external usenet poster

Posts: 1

Default

custom number format code using letters and numbers

On Monday, August 17, 2009 at 7:26:01 AM UTC-7, Foo Foo Foo Daddy wrote:
How can I format my cell to display letters, a dash, then #s? For example:
ABC-12345678, or 2DE-12347562, or FG3-46518673?

If the string of numbers after the letters is always the same legnth and the unformatted TEXT Looks like ABC12345678 you could do the following

to format ABC12345678 in Cell A1 as ABC-12345678 in Cell B1: =LEFT(A1,3)&"-"&RIGHT(A1,8)

--
*The information contained in this message is the sole and exclusive
property of **iHerb Inc.** and may be privileged and confidential. It may
not be disseminated or distributed to persons or entities other than the
ones intended without the written authority of **iHerb Inc.* *If you have
received this e-mail in error or are not the intended recipient, you may
not use, copy, disseminate or distribute it. Do not open any attachments.
Please delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.*

Reply With Quote

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
Custom number code [conditional] help	[email protected]	Excel Worksheet Functions	13	January 22nd 08 03:39 AM
Custom number format contain letters?	Phillip	Excel Discussion (Misc queries)	2	January 23rd 07 04:02 PM
Custom number format codes for negative numbers	IJ	Excel Discussion (Misc queries)	5	September 7th 06 09:54 PM
how do I add phone number format as a permanent custom format?	frustratedagain	Excel Discussion (Misc queries)	3	February 4th 06 03:52 AM
How do I change format of page numbers to letters in Excel?	DonnaGoof	Excel Discussion (Misc queries)	2	November 15th 05 07:35 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement