Entering data into Excel spreadsheet

J

jgandz

Using Office 2008 on IMAC 24, Leopard 10.5.2

When I input ANY number into an excel spreadsheet it divides by 10.

10000 become 1000
1 becomes .1

Help!
 
C

CyberTaz

Take a look in Excel> Preferences> Edit, clear the check for "Display this
number of decimal places" or set it to 0.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Top