G
Guest
can anyone help me fix this problem?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
gls858
acsnett said: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
D
David McRitchie
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/excel.htm#tutorials
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/excel.htm#tutorials