Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2006

Tip: Looking for answers? Try searching our database.

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
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
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
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.