Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

cell entry

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
afdmello - 23 Jun 2007 21:10 GMT
when I type " -ve root " without the inverted commas and hit enter I get
#name? how do I solve this?

afd
Dave Peterson - 23 Jun 2007 21:23 GMT
Excel thinks you want to start a formula with the negative sign.  

You can either prefix your entry with an apostrophe or preformat the cell as
text.

> when I type " -ve root " without the inverted commas and hit enter I get
> #name? how do I solve this?
>
> afd

Signature

Dave Peterson

Rick Rothstein (MVP - VB) - 23 Jun 2007 21:29 GMT
> when I type " -ve root " without the inverted commas and
> hit enter I get #name? how do I solve this?

If you select the cell after doing the above and look a the formula bar, you
will see Excel tried to "help" you out when it saw the leading minus sign
(you probably thought of it as a dash when you typed it) and added the equal
sign attempting to make it a formula for you. Of course, it is not a valid
formula (no functions are named 've'); hence, the error. You can place an
apostrophe (the unshifted quote mark key) first and then type the '-ve root'
after it to force the entry to be text. Alternately, you can format the
cell, cells of column as Text and then you would not need to use the
apostrophe.

Rick
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.