Custom Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cliff - 17 Apr 2008 15:06 GMT

Hi, I need to format text and numbers, but I keep messing up.
For example, I want to format
A12345678901 so that it will appear as
A123-4567-8901

Please help?

Reply to this Message

Gary''s Student - 17 Apr 2008 15:36 GMT

Start with 12345678901 in a cell. Then:

Format > Cells > Custom > "A"000-0000-0000

Don't manually enter the "A", let the formatting do it.

Signature

Gary''s Student - gsnu200779

> Hi, I need to format text and numbers, but I keep messing up.
> For example, I want to format
> A12345678901 so that it will appear as
> A123-4567-8901
>
> Please help?

Reply to this Message

Frank - 18 Apr 2008 18:17 GMT

Assuming the original numbers are always 1 alpha and 10 numeric digits, this
should work...

=LEFT(D6,1) & TEXT(VALUE(RIGHT(D6,9)),"000-0000-0000")

Francis J Hayes (The Excel Addict)

www.TheExcelAddict.com
Helping Average Spreadsheet Users
Become Local Excel Experts

> Hi, I need to format text and numbers, but I keep messing up.
> For example, I want to format
> A12345678901 so that it will appear as
> A123-4567-8901
>
> Please help?

Reply to this Message

Rate this thread: