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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Cell Format in a List
In a list created from DataCreate List
The custom format ####"-"##### works for me if the accounts do not have any text. 123456789 returns 1234-456789 1234567RE returns 1234567RE I have no idea why your XXXX"-"XXXXX would work anywhere or are the "X"'s a typo? Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 14:07:01 -0700, Courtney wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Cell Format in a List
Okay, I feel stupid--I must have used the ## outside of my list and XX
inside, duh! But I would still like to be able to have letters or numbers after the hypen, do you know a way to do that? 99% of what I put in that column has letters. Thanks so much for taking the time to look at this! "Gord Dibben" wrote: In a list created from DataCreate List The custom format ####"-"##### works for me if the accounts do not have any text. 123456789 returns 1234-456789 1234567RE returns 1234567RE I have no idea why your XXXX"-"XXXXX would work anywhere or are the "X"'s a typo? Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 14:07:01 -0700, Courtney wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Cell Format in a List
You cannot custom format text in Excel
-- Regards, Peo Sjoblom "Courtney" wrote in message ... Okay, I feel stupid--I must have used the ## outside of my list and XX inside, duh! But I would still like to be able to have letters or numbers after the hypen, do you know a way to do that? 99% of what I put in that column has letters. Thanks so much for taking the time to look at this! "Gord Dibben" wrote: In a list created from DataCreate List The custom format ####"-"##### works for me if the accounts do not have any text. 123456789 returns 1234-456789 1234567RE returns 1234567RE I have no idea why your XXXX"-"XXXXX would work anywhere or are the "X"'s a typo? Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 14:07:01 -0700, Courtney wrote: 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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Cell Format in a List
How disapointing! Thanks for telling me though, at least now I can stop trying.
I think that is something that Microsoft needs to change... Thanks again! "Peo Sjoblom" wrote: You cannot custom format text in Excel -- Regards, Peo Sjoblom "Courtney" wrote in message ... Okay, I feel stupid--I must have used the ## outside of my list and XX inside, duh! But I would still like to be able to have letters or numbers after the hypen, do you know a way to do that? 99% of what I put in that column has letters. Thanks so much for taking the time to look at this! "Gord Dibben" wrote: In a list created from DataCreate List The custom format ####"-"##### works for me if the accounts do not have any text. 123456789 returns 1234-456789 1234567RE returns 1234567RE I have no idea why your XXXX"-"XXXXX would work anywhere or are the "X"'s a typo? Gord Dibben MS Excel MVP On Thu, 27 Sep 2007 14:07:01 -0700, Courtney wrote: 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? |
Reply |
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) |