Maybe the cell is formatted as text - click on the cell and use Format
| Cells | Number (tab) to check how the cell is formatted.

Hope this helps.

Pete