If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
when i enter a dollar amount of 18.40 into excel it drops the 0
can anyone help me fix this problem?
|
#2
|
|||
|
|||
hi,
it would be better if you put your question in the body of your post and not in the subject. your question is truncated so i am not sure exactly what your question is. Regards FSt1 "acsnett" wrote: can anyone help me fix this problem? |
#3
|
|||
|
|||
acsnett wrote:
can anyone help me fix this problem? Try formatting the cells as currency. Hight the cell or cells right click select format in the numbers tab select currency. gls858 |
#4
|
|||
|
|||
Not having a complete statement of the problem in the body is indeed
confusing. Anyway I do see question without truncation on the subject line. You have to fix the problem yourself by formatting the cell. Select the cell, or preferably and entire column so you have only one format and then use Format, cells, number and make an appropriate choice with two decimal digits. You can use the format buttons on your toolbars with the comma and the increase/decrease decimal places. http://www.mvps.org/dmcritchie/excel/formula.htm format, cells, number choose number of decimal places choose whether you want a comma (may be a different char if not US/Canada) choose the format such as red negative numbers with minus or in parens. More choices under accounting. You also have the toolbar formatting buttons. You might also look at any choice you've made under format, cells, custom -- to see how it was actually done This is rather basic stuff so if that is not clear I would suggest you look at a couple of tutorials. http://www.mvps.org/dmcritchie/excel....htm#tutorials --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "FSt1" wrote in message ... hi, it would be better if you put your question in the body of your post and not in the subject. your question is truncated so i am not sure exactly what your question is. Regards FSt1 "acsnett" wrote: can anyone help me fix this problem? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I enter Outlook contact data into excel? | FSTC892 | General Discussion | 4 | June 9th, 2005 05:25 PM |
How do i enter negative times in Excel & how can they be 'fiddled. | stuck! | General Discussion | 2 | April 7th, 2005 02:05 PM |
Enter key not working in Excel | Dana | General Discussion | 1 | July 30th, 2004 10:41 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |