Can you give us more details. What are you exporting from? Access?
Also, if you have a column of numbers that excel has stored as text you
can tell this from the fact that text aligns to the left of the cell,
and numbers align to the right of the cell.

A quick way to convert a column of numbers stored as text into number
format is:

1) Type the number 1 in an empty cell
2) Select the cell and COPY
3) Select the complete column of numbers stored as text
4) Right click and select 'Paste Special'
5) Select 'Multiply' (from the 'operation' section of paste values
6) Click OK

This will convert every value in the column to actual number format,
which you can tell by the fact that the values will now be aligned to
the right.

(You can obviously then delete the 1)

Jay
__


Thomas wrote:
Try http://www.sqlscripter.com to export data to Excel.

"Peledon" wrote:

How come when I export data to excel and reformat a column to numbers, it
doesn't recognise them as numbers and I have to retype the numbers in a
separate column to calculate them.
HELP PLEASE.