typed numbers entered in cell wrong

G

Guest

I typea number in a cell and it appears divided by 10 i.e type 90 enter amd
..9 appears in cell
 
G

Guest

Try this:

From the Excel main menu:
<tools><options><edit tab>
Uncheck: Fixed decimal places

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
C

Chip Pearson

Go to the Tools menu, choose Options, then the Edit tab. There,
uncheck the "Fixed decimal" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Excel Typed text appears in wrong cell 0
Cell shows the last typed text, no matter where it is typed 0
COUNT function - # of occurences a number appears in all cells 26
excel numbers eentered appear wrong 1
# symbol appearing instead of typed text in a cell 1
MM/YY Formatting date Entry AND Display 2
default format for Excel numbers 3
I don't need the actual value but what is shown 2

Top