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

  • Thread starter Thread starter Tristan
  • Start date Start date
T

Tristan

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

| 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
 
Back
Top