Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default Last name True won't format

I have a spreadsheet with a person whose last name is True. This name will
not format. Is there a way to make this name format like the rest of the
names?

Thanks
Becky
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 833
Default Last name True won't format

EXCEL 2007

Try this:

'True

If my comments have helped please hit Yes.

Thanks.

"Becky" wrote:

I have a spreadsheet with a person whose last name is True. This name will
not format. Is there a way to make this name format like the rest of the
names?

Thanks
Becky

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 73
Default Last name True won't format

Thank you that worked.

Becky

"trip_to_tokyo" wrote:

EXCEL 2007

Try this:

'True

If my comments have helped please hit Yes.

Thanks.

"Becky" wrote:

I have a spreadsheet with a person whose last name is True. This name will
not format. Is there a way to make this name format like the rest of the
names?

Thanks
Becky

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I format cells containing a value to display as true/false gootroots Excel Discussion (Misc queries) 3 May 11th 23 07:43 PM
Conditional Format--2 conditions need to be true CrimsonPlague29 Excel Worksheet Functions 2 June 26th 08 04:42 PM
Formula to recognize if another cell's conditional format is true Shu of AZ Excel Discussion (Misc queries) 2 December 19th 06 03:19 AM
Logical Format showing 0/1 and not True/False. Tony Excel Discussion (Misc queries) 2 June 1st 06 08:58 AM
Function to return True/False if all are validated as True by ISNU Tetsuya Oguma Excel Worksheet Functions 2 March 15th 06 10:28 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"