Can't figure out how to stop a decimal being used for a new worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tristan - 14 Dec 2006 21:24 GMT

Hi,

Just installed Office 2007 on my fathers machine, everytime we do a new
worksheet and type in 12345 it changes to 123.45. It's like a global
setting but we can't figure out how to remove it.

Any ideas.

Thanks
Tristan

Reply to this Message

Niek Otten - 14 Dec 2006 21:37 GMT

Office Button (Upper left corner)>Excel Options>Advanced>Uncheck Automatically insert a decimal point

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
[quoted text clipped - 6 lines]
| Thanks
| Tristan

Reply to this Message

Tristan - 14 Dec 2006 23:09 GMT

Thanks will give that a go.

Tristan

> Office Button (Upper left corner)>Excel Options>Advanced>Uncheck
> Automatically insert a decimal point
[quoted text clipped - 9 lines]
> | Thanks
> | Tristan

Reply to this Message

Joerg - 15 Dec 2006 08:20 GMT

Tools => Options => Edit
There remove checkmark from 'fixed decimal'

Cheers,
Joerg Mochikun

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks
> Tristan

Reply to this Message