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 / October 2007

Tip: Looking for answers? Try searching our database.

Cell Format Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kendrickmr@gmail.com - 03 Oct 2007 15:13 GMT
My excel worksheet is Formatted to 'General', but when I try to type
in a number, it automatically moves the decimal 2 places (e.g. I type
"34" and excel reads "0.34" or I type "156" and excel read "1.56") The
problem still occurs when I format the cells to "Number - 0 Decimal"
or "Number 2 Decimal." If I type "36.0" then excel does read 36.0,
which thus far is my only way around this, but that is a lot of extra
numbers to type when doing large spreadsheets. I hope this is an easy
fix that I am somehow looking over, but if anyone has suggestions, I
would be more than happy to hear them. Thanks for the Help.
 Michael
Peo Sjoblom - 03 Oct 2007 15:19 GMT
Tools>options>edit and deselect fixed decimal places

Signature

Regards,

Peo Sjoblom

> My excel worksheet is Formatted to 'General', but when I try to type
> in a number, it automatically moves the decimal 2 places (e.g. I type
[quoted text clipped - 6 lines]
> would be more than happy to hear them. Thanks for the Help.
>  Michael
 
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.