How do I get the $ off

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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 must log in or register to reply here.

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

Time calculations 3
Delete some substotal in a pivot table 1
Excel Formula or equation 3
I'm a salaried employee, ?how to calculate actual rate of pay 20
Excel The logic hurts my head 5
auto zero cell data on a function??? 6
Weekly Timesheet help 3
Need Formula to Calculate Time/Overtime 2

Back
Top