 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007numbers & decimals
In Excel spreadsheet 2007, I have a column I want to enter figures like these: 5.00 4.90 5.25 etc. I enter the figure, leave the cell and it goes to 0 or to 500, or to4.9. I can't keep in there what I want. Select the cells required and on the Home ribbon, click on the little arrow bottom right of Number block (about middle of ribbon), select number then set the number of decimal places to display. Regards, OssieMac > In Excel spreadsheet 2007, I have a column I want to enter figures like these: > [quoted text clipped - 4 lines] > I enter the figure, leave the cell and it goes to 0 or to 500, or to4.9. I > can't keep in there what I want.
|
Reply to this Message |
 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.