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? |
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? |
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? |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com