ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Last name True won't format (https://www.excelbanter.com/excel-discussion-misc-queries/259807-last-name-true-wont-format.html)

Becky

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

trip_to_tokyo[_3_]

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


Becky

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



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com