 |
 | 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 / January 2007Formatting Numbers Help
Hi there! Is it possible to type 1210 into a cell and have it formatted with a decimal automatically placed to make it 12.10. If so is it possible to have it summed in another cell to =Sum(A1:A3) in which you have 1210 entered in all three cells... the total would be 3630 formatted as 36.30 Is this possible? Thanks Craig Using Tools | Options, opening the Edit tab and setting Fixed Decimal ON and set to 2 you can enter 1210 and have 12.10 appear in the cell. However, this will apply to ALL cells in all books that you open until you reset the option As for the SUM() questions, why not =SUM(A1:A3)*100 best wishes from Nova Scotia  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > Hi there! > [quoted text clipped - 6 lines] > Thanks > Craig
|
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.