 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007Creating Formulas
I am entering numbers in cells and Excel is automatically turning them into some type of formula, which I don't want it to do, but I can't stop it. Help! Either the numbers your entering are more than 11 digits or you've inadvertently changed the cell formatting to Scientific. Either way, select the cells, go to Format> Cells - Number & change the cell formatting to Number, Currency or Accounting, whatever is appropriate. HTH |:>) Bob Jones [MVP] Office:Mac On 8/17/07 8:10 PM, in article 1187395859.973389.283290@r23g2000prd.googlegroups.com, > I am entering numbers in cells and Excel is automatically turning them > into some type of formula, which I don't want it to do, but I can't > stop it. Help! > I am entering numbers in cells and Excel is automatically turning them > into some type of formula, which I don't want it to do, but I can't > stop it. Help! It's hard to diagnose unless you give an example or two. What numbers are you entering? How are the cells formatted? What does the formula bar show after you hit enter? |
Reply to this Message |
 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
|
©2009 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.