| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format from 870914143 to 8-709-14143
THANK YOU SO MUCH ALL
"Toppers" wrote: Format cell as: Custom==0-000-00000 HTH "Mary" wrote: Hi, I have a column that I would like to format like the sample below. I want to keep the dashes between the numbers. from 870914143 to 8-709-14143 Thank you so much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Hybrid Mode
