The cell must be currently formatted as text, select Format -> Cells and
choose General. Then, click on your cell and hit F2 and hit enter to refresh
the formula
Your cell was probably formatted as text before you entered the formula.
Format the cell as General, then go into the formula bar and confirm the
formula again.
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.