Excel changes decimal

  • Thread starter Thread starter davidcay
  • Start date Start date
D

davidcay

Newly installed Office 2008 for Mac inserts decimal, for example, 17
becomes 1.7. How to fix?
 
Hi,

I don't know where it is in Excel 2008 but in 2003 you go

Tools|Option|Edit
and un-check fixed decimal places so I guess you might look in Help for
Fixed Decimal Places and try that.

Mike
 
On 2008 there is NO such listing under tools and putting "fixed
decimal" in help returns "no results.

Ayone else?
 
On 2008 there is NO such listing under tools and putting "fixed
decimal" in help returns "no results.

Ayone else?
Click to expand...

Options in Excel is called Preferences on a Mac and should be under
the application menu. That is the menu called "Excel" in this case.
Also usually accessible with "CMD-,". That's the Command key (also
known as Apple key) and comma.

I don't have 2008 and don't trust Microsoft to match conventions, so I
can't be sure of all this.
 
You must log in or register to reply here.

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

Convert Decimal fractions to binary and vice versa 1
Excel Column Summation 10
Decimal point in general format 1
Count digits before decimals and after decimals 4
problem with number format with 2 decimals? 5
Change number from multiple decimals to 2 3
Custom Section Numbering 6
excel 2003 zero as last decimal 5

Back
Top