Home |
Search |
Today's Posts |
#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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I enter more than one line in the same Excel Cell by using. | Excel Discussion (Misc queries) | |||
How do I enter a slash character in excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do i enter negative times in Excel & how can they be 'fiddled. | Excel Discussion (Misc queries) | |||
Excel - cursor moves to other cells after I enter data, without h. | Excel Discussion (Misc queries) |