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.
Excel Problem
Name: delski Date: January 29, 2006 at 18:51:42 Pacific OS: XP PRO (desktop) CPU/Ram: 250
Comment:
When I type text into a spreadsheet line & press enter all that comes up is #NAME? What can I do to just have what I typed into the line be there. Excel help has some info on this #NAME? but I can't understand what they are talking about. If I type the words pricing information it shows with no problem but if I type --- pricing information & press enter all I get is #NAME?
Name: j mclaren101 Date: January 30, 2006 at 06:29:31 Pacific
Reply:
Excel interprets --- as maths so what you are doing is maths on text, try enclosing your words in quotes as follows: "--- pricing information".
0
Response Number 2
Name: j mclaren101 Date: January 30, 2006 at 06:31:56 Pacific
Reply:
Oops I forgot put an = in front of the quotes as follows ="--- pricing information". Sorry about that.
0
Response Number 3
Name: Jennifer SUMN Date: January 30, 2006 at 12:14:44 Pacific
Reply:
By default, your cells are formatted as General. If you type in --- before the text, Excel thinks you're attempting to type a formula, thus the error. You need to make sure that your cell is formatted as Text BEFORE typing the information in the Cell.
Summary: I have a major excel problem.Yesterday Excel began acting up, seemingly arbitrarily. Opening either a specific spreadsheet OR the program itself caused my system to freeze, and get a 'low resources' w...
Summary: Hi Nishant nice to meet you ! This is for sure some problem with excell application files corrupted, repare MS-Office option shoud help. http://www.webhelpboard.com - Immediate online help ...
Summary: I'm entering a column of data onto an Excel worksheet (Office XP). Most of the cells are entering correctly--mmddyy. However, some of the cells end up saying 1E+05. I've gone back to be sure that the ...
0 
