How do I get the $ off

C

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Turning off automatic calculation 0
How to have two tables on same line? 1
Time calculations 3
I have lost 6 months work, how can i get my file back 1
Images are pixelated when saving to PDF 0
Shared Link is showing empty notebook 1
Office365 Family + TXT or MX Domain 0

Top