Text formatting in Excel wont work

February 13, 2009 at 08:35:36
Specs: Windows XP
My Excel data won't format as text when I use the menu. If I enter the comma (') before the data it formats okay.

See More: Text formatting in Excel wont work

Report •


#1
February 13, 2009 at 10:17:02
What data is in the cell? Text or numbers?

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

#2
February 13, 2009 at 10:29:46
Numbers that I want to format as text.

ID Number Name
123456 Any Name


Report •

#3
February 13, 2009 at 14:18:48
You mean apostrophe... A comma looks like this ,

If the Cell is formatted as text, then the numbers will display properly. If the cell is formatted as "General," which is the default, you will need to enter an apostrophe in order for the zero to show.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


Report •

Related Solutions

#4
February 13, 2009 at 15:12:09
My Excel data won't format as text when I use the menu.

What do you mean "won't"?

Please give an example of what you expect to happen vs. what actually happens.

There may be other solutions besides the apostrophe.


Report •


Ask Question