I get this problem a lot when i import from another data source. Add a column
and multiply the original cell by 1. For ex, in cell B1 Type =A1*1

"neil" wrote:

When ever i start excel 2003 and type numbers they come up as text so i can
not use any functions, i have tried formatting the cells to numbers but this
does not work, i have even re-installed office with no luck, can any body
help me