| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a column from E605EQ1212 to E 605 EQ 1212
On Wed, 14 Feb 2007 07:38:35 -0800, Scott at Scott <Scott at
wrote: Please Help, I've done every thing the online help provided. Like below in the Custom block \A 000 \A\A 0000 E 000 "EE" 0000 "E" 000 "EE" 0000 I need it to auto format to look like this E 605 EQ 1212 Thank You for your time. Format/Cells/Number/Custom Type: "E "000 "EQ "0000 Then, in the cell, enter: 6051212 It will then display: E 605 EQ 1212 --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Label Format to Column Format | Excel Discussion (Misc queries) | |||
| how do I remove data from cells ex. (232)-555-1212 to 2325551212 | Excel Discussion (Misc queries) | |||
| Format a column wihtout using "Format-Cells-Number-category-etc" | Excel Worksheet Functions | |||
| format a column | Excel Discussion (Misc queries) | |||
| Format a certain column | Excel Discussion (Misc queries) | |||
Threaded Mode
