when i enter a dollar amount of 18.40 into excel it drops the 0
can anyone help me fix this problem?
|
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? |
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 |
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? |
All times are GMT +1. The time now is 05:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com