Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Really simple question for a simpleton!
I have started to like custom formatting and often use it for things like "Year Created = "0000 so that I don't need to have a separate adjacent cell telling the reader what the value is. In this case, the cell contents is just a text string with a maximum of 30 characters, mostly all letters and spaces. I don't know what to use (the equivalent of 0000 for four digits) to tell it to allow any general character, most likely a letter or space. Please help. Thanks Dean |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
="Year Created = "@
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dean" wrote in message ... Really simple question for a simpleton! I have started to like custom formatting and often use it for things like "Year Created = "0000 so that I don't need to have a separate adjacent cell telling the reader what the value is. In this case, the cell contents is just a text string with a maximum of 30 characters, mostly all letters and spaces. I don't know what to use (the equivalent of 0000 for four digits) to tell it to allow any general character, most likely a letter or space. Please help. Thanks Dean |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I guess I should have figured that out. Thanks!
Dean "Bob Phillips" wrote in message ... ="Year Created = "@ -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dean" wrote in message ... Really simple question for a simpleton! I have started to like custom formatting and often use it for things like "Year Created = "0000 so that I don't need to have a separate adjacent cell telling the reader what the value is. In this case, the cell contents is just a text string with a maximum of 30 characters, mostly all letters and spaces. I don't know what to use (the equivalent of 0000 for four digits) to tell it to allow any general character, most likely a letter or space. Please help. Thanks Dean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom trendline syntax | Excel Discussion (Misc queries) | |||
Office 2007 Custom UI Ribbon - Syntax Check | Excel Programming | |||
Office 2007 Custom UI Ribbon - Syntax Check | Excel Programming | |||
Office 2007 Custom UI Ribbon - Syntax Check | Excel Programming | |||
Custom Format syntax Q | Excel Discussion (Misc queries) |