PC Review


Reply
Thread Tools Rate Thread

custom format syntax ques

 
 
Dean
Guest
Posts: n/a
 
      25th Aug 2007
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 With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      25th Aug 2007
="Year Created = "@

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Dean" <(E-Mail Removed)> wrote in message
news:9JqdnZH0q4QJ-(E-Mail Removed)...
> 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 With Quote
 
Dean
Guest
Posts: n/a
 
      25th Aug 2007
I guess I should have figured that out. Thanks!

Dean

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:OP%(E-Mail Removed)...
> ="Year Created = "@
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
> "Dean" <(E-Mail Removed)> wrote in message
> news:9JqdnZH0q4QJ-(E-Mail Removed)...
>> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with converting CUSTOM format/TEXT format to DATE format Deo Cleto Microsoft Excel Worksheet Functions 6 2nd Jun 2009 08:14 PM
Custom Syntax Development Lucky Microsoft C# .NET 5 27th Mar 2009 11:21 PM
Custom trendline syntax Matt Microsoft Excel Misc 0 6th Nov 2007 12:33 PM
How to add a text editor with custom syntax highlighting into my custom app GreggTB Microsoft Dot NET 3 21st Jan 2007 02:39 AM
Custom Format syntax Q =?Utf-8?B?bmFzdGVjaA==?= Microsoft Excel Misc 4 25th Apr 2006 07:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:20 PM.