Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Custom Formatting
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Custom Formatting
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. -- Gary''s Student - gsnu200779 "cliff" wrote: 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Custom Formatting
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 "cliff" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom formatting | Excel Discussion (Misc queries) | |||
Custom formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Custom Formatting | Excel Worksheet Functions | |||
custom formatting ???/???? | Excel Discussion (Misc queries) |