| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't format column
Hello,
I'm trying to custom format a column but nothing happens when I apply the formatting. The column contains entries such as this: N163975A B142237K B141917K B144973K B189601K and I'm trying to format them so they look like this: N16-3975-A B14-2237-K B14-1917-K B14-4973-K B18-9601-K I've confirmed the tools/options/view and the formula box is unchecked. I have also cleared all formatting before trying to apply my own and still nothing. TIA, Marta |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| How do I format the A/ B Column to be fixed like numeric column | Excel Worksheet Functions | |||
| Label Format to Column Format | Excel Discussion (Misc queries) | |||
| Format a column wihtout using "Format-Cells-Number-category-etc" | Excel Worksheet Functions | |||
Threaded Mode
