Excel 2007 number format

[Andy]

Every number I entre in a spread sheet has decimile place even though it is
set to General. e,g I enter 127 I get 1.27. This has only just started
happening and I can't find a soution to this problem. All my saved spread
sheet are in general and are fine but if I add a number to any sheet it comes
up with he decimail point. This is driving me crazy.. Help please.

I have office 2007 on Vista business.

 

[Ron Rosenfeld]

Every number I entre in a spread sheet has decimile place even though it is
set to General. e,g I enter 127 I get 1.27. This has only just started
happening and I can't find a soution to this problem. All my saved spread
sheet are in general and are fine but if I add a number to any sheet it comes
up with he decimail point. This is driving me crazy.. Help please.

I have office 2007 on Vista business.

Select:

Office Button
Excel Options
Advanced
Editing Options
DE-select "Automatically insert a decimal point"

--ron

 

[Andy]

Cheers Ron Many thanks!
--
Ian D Anderson

Select:

Office Button
Excel Options
Advanced
Editing Options
DE-select "Automatically insert a decimal point"

--ron

 

[Ron Rosenfeld]

Cheers Ron Many thanks!

You're most welcome. Glad to help.
--ron