Forum Discussion
Solved
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.
=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.
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