"yahoo" wrote
They are defined as text - how do i convert the mto numbers
I used Format - cells - number - but it did not work

Bas van Heek wrote:
Are you sur the cells containing numbers are defined as numbers
(format cells-Numbers)? If they are defined as text
you cannot calculate them..

Formatting does not change the underlying values

Try this:

Right-click on an *empty* cell Copy
Right-click on the range/col of "text" numbers
Choose Paste special Add OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----