Forum Discussion
excel default type of cell
i am finding that when i enter a formula ( e.g. -a1+a2 ) that i am getting an error that this is the wrong type of data . how do i rectify this error
In a newly created workbook, all cells are formatted as in the Normal style.
If you have created a default template Book.xltx, the style from that template will be used.
Otherwise, Normal will be as follows:
Note: the font depends on the setting in File > Options > General.
14 Replies
- =A1+A2
When you enter the formula like this, do you get an error message?
If yes, which; A photo or file (without sensitive data) would be an advantage.- tes it says wrong data type. it seems that my excel data type always defaults to a char$ so it thinks that i am trying to add letters
What do cells A1 and A2 contain?
they just contain numbers with one decimal point.
If you set the horizontal alignment of A1 and A2 to General, are the values left-aligned or right-aligned? If they are left-aligned, they are text values even if they look like numbers.
You should be able to correct that by selecting each cell, pressing F2 then Enter.
