excel 2003 subtract function

T

Trebla

Help item in Excel 2003
Subtract numbers in a cell
To do this task, use the - (minus sign) arithmetic operator.
For example, if you type the following formula in a cell:
10-5
The cell displays the following result:
5
I am trying to do the above in an Excel 2003 blank spreadsheet that has the
cell formatted as general. The result is not appearing as 5 but as a date 10
May or a large number 39823.00. Could you please assist in telling me what
the problem is?
 
D

David Biddulph

An Excel formula starts with an equals sign

10-5 is not a formula
=10-5 is a formula.
 
G

Glenn

Trebla said:
Help item in Excel 2003
Subtract numbers in a cell
To do this task, use the - (minus sign) arithmetic operator.
For example, if you type the following formula in a cell:
10-5
The cell displays the following result:
5
I am trying to do the above in an Excel 2003 blank spreadsheet that has the
cell formatted as general. The result is not appearing as 5 but as a date 10
May or a large number 39823.00. Could you please assist in telling me what
the problem is?

This is what it says in my help file...

Subtract numbers

Type =10-5 in a cell to display the result 5.
 

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

Top