Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Cell Format in a List
I have a worksheet which is formatted as a list, so that I have the little
filters at the top of each column. It is great, except I cannot get "Custom Cell Format" to work in it. Are they incompatible? For example, I have a column of account numbers, which always have 4 numbers, a hypen, and then 5 numbers or letters. I try the custom number format XXXX"-"XXXXX which works outside of the list, but it will not take affect in the list. Is there anything I can do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Cell Format, Zero Pad | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Custom Cell Format | Excel Worksheet Functions | |||
custom list with accounting format | Excel Discussion (Misc queries) |