Excel must be forced to see the data as Numeric.

One way is to format all to Number or General then copy an empty cell.

Select the data copy then, in place, Paste SpecialAddOKEsc.

Or select the data and DataText to ColumnsNextNextColumn Data
FormatGeneralFinish.

Now format to Number


Gord Dibben MS Excel MVP

On Thu, 1 Feb 2007 13:02:00 -0800, mikybi
wrote:



„merlin68" napísal (napísala):

I have retrieved some data from external source and it put to my
worksheet in one column numbers in text format and if I want to work
with numbers (add, substract, etc.) I need it to convert to number format.
I tried to select column and mark it as number format however it doesn´t
work. Pls help me what to do, how to suceed. I have no chance to change
the format in source.

Juraj