 |
 | 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 / Worksheet Functions / September 2007Setting formatting for 2 places
I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are 7.47 and some are 125.69. I have the columns formatted for 2 places. Is there anyway to simply enter a number in a specific column and not have to enter the decimal while entering the number and have it automatically make it 2 decimal places. Example when I enter 2450 it formats the number 2450.00 which is perfect - that is what I want it to do. But, if I enter 7.47 I have to enter the decimal or else it formats 747.00. Is there anyway to make that column format 7.47? Jannie There is no way to do this in just one column You can have the whole worksheet behave that way with Tools|Options; open the Edit tab and check the Fixed Decimals box and specify 2 decimal places You could do this; enter your values and then uncheck the box. or if it is a one-off affair: enter the numbers with out decimals type 100 in an empty cell copy the cell select the numbers to be 'fixed'; use Edit Paste Special->specify Divide now you can delete the 100 best wishes  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email >I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are > 7.47 and some are 125.69. I have the columns formatted for 2 places. Is [quoted text clipped - 9 lines] > 7.47? > Jannie Just a precaution to keep in mind: Bob's post is the only ways I can think of as well. However, If you use the Tools-->Options methied, for numbers such as 2450, you will need to enter 245000 or it will enter 24.50. If you go with the Paste Special-->Divide method, it will divide ALL selected cells by 100, including the 2450 if it is selected, making it 24.50. > I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are > 7.47 and some are 125.69. I have the columns formatted for 2 places. Is there [quoted text clipped - 7 lines] > 7.47? > Jannie Thank you! > I have a worksheet with 3 columns. Some numbers are like. 2450.00. Some are > 7.47 and some are 125.69. I have the columns formatted for 2 places. Is there [quoted text clipped - 7 lines] > 7.47? > Jannie |
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.