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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tristan" <(E-Mail Removed)> wrote in message news:9018683A-27A3-4739-A789-(E-Mail Removed)...
| 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
|

Thanks will give that a go.

Tristan


"Niek Otten" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Office Button (Upper left corner)>Excel Options>Advanced>Uncheck
> Automatically insert a decimal point
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Tristan" <(E-Mail Removed)> wrote in message
> news:9018683A-27A3-4739-A789-(E-Mail Removed)...
> | 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
> |
>
>

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

Cheers,
Joerg Mochikun

"Tristan" <(E-Mail Removed)> wrote in message
news:9018683A-27A3-4739-A789-(E-Mail Removed)...
> 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
>