Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Text formatting in Excel wont work
Name: DMcC Date: February 13, 2009 at 08:35:36 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
My Excel data won't format as text when I use the menu. If I enter the comma (') before the data it formats okay.
Name: Jennifer SUMN Date: February 13, 2009 at 10:17:02 Pacific
Reply:
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
0
Response Number 2
Name: DMcC Date: February 13, 2009 at 10:29:46 Pacific
Reply:
Numbers that I want to format as text.
ID Number Name 123456 Any Name
0
Response Number 3
Name: Jennifer SUMN Date: February 13, 2009 at 14:18:48 Pacific
Reply:
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
0
Response Number 4
Name: DerbyDad03 Date: February 13, 2009 at 15:12:09 Pacific
Reply:
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.
Summary: Hi, From your reply, I am not entirely clear how this is meant to work. Is this what you have: Rows of data (i.e., records) which may be New, Evaluated etc. There is a drop down list in a cell at the...
Summary: Hi I'm trying to work out how to devise a formula in Excel 2003 which does the following ... Searches a range of cells for a certain text value 'False' in worksheet "Data", if it finds it, this Text i...
Summary: Okay. Now I understand what you are trying to do. The only way I know of is to use VBA code. You would have to convert the raw number into a format that Excel would recognize as a date 20051001 into ...
0 
Excel Macro - Moving file...
