changing numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dougcoms@officeformac.com - 27 Jul 2008 20:11 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm simply trying to type numbers in cells. I can't get Excel to leave them alone. It changes them from 760 to .076 (for example). Trying to reformat as General stays the same, reformating as number changes it to .08. I've tried to make it work in new workpages to no avail. I've tried conditional formating and styles also to no avail. I've lost two days on this. Please bring back Excel 2004!

Reply to this Message

Niek Otten - 27 Jul 2008 20:56 GMT

From a fellow Mac user (herman):

I got the solution from Microsoft. it has to do with a preference. Go to edit, there wil be a box at: display this number of
decimals, uncheck this, restart the programm and the problem is solved.

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Version: 2008
| Operating System: Mac OS X 10.5 (Leopard)
| Processor: Intel
|
| I'm simply trying to type numbers in cells. I can't get Excel to leave them alone. It changes them from 760 to .076 (for example). Trying to reformat as General stays the same, reformating as number changes it to .08. I've tried to make it work in new

workpages to no avail. I've tried conditional formating and styles also to no avail. I've lost two days on this. Please bring back
Excel 2004!

Reply to this Message

Mike Middleton - 27 Jul 2008 21:36 GMT

dougcoms -

Excel | Preferences | Edit | uncheck Display this number of decimal places

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 6 lines]
> conditional formating and styles also to no avail. I've lost two days on
> this. Please bring back Excel 2004!

Reply to this Message

Mac Forum / Applications / Excel / July 2008

changing numbers