G Guest Oct 5, 2005 #1 I am new and on a test at school, it had a sheet with overtime hrs. I can't find why it is adding the $ automatically. Thanks ckr
I am new and on a test at school, it had a sheet with overtime hrs. I can't find why it is adding the $ automatically. Thanks ckr
T Timothy L Oct 5, 2005 #3 The cells were formatted as Currency. Select the cell(s), row(s), or column(s), then click Format -> Cells... Now choose the correct format and click "OK" when done.
The cells were formatted as Currency. Select the cell(s), row(s), or column(s), then click Format -> Cells... Now choose the correct format and click "OK" when done.
B Bernard Liengme Oct 5, 2005 #4 You have answers telling how to fix but not explaining how it happened Sometimes Excel it too helpful. If A1 holds $3 and B1 holds 2, then with C1=A1*B1 you get $12 because Excel 'carries' the formatting over to the result.
You have answers telling how to fix but not explaining how it happened Sometimes Excel it too helpful. If A1 holds $3 and B1 holds 2, then with C1=A1*B1 you get $12 because Excel 'carries' the formatting over to the result.
