Creating Formulas

E

editor

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!
 
C

CyberTaz

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
 
J

JE McGimpsey

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!
Click to expand...

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Paste to excel from word - auto format problem 1
Excel - Wich Function should I use? 1
How to paste this down? 3
Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0
No option to create a list in SharePoint Site 0
Excel does not accept text format! 0

Top