Hello,

I have a worksheet where column A contains reference numbers, eg
000001346, 000001347, 000001542 etc.
What formula can I create in column B that will find all entries in
column A that begin with 0000013 and add them up?

The other factor is that this data is imported from an external system
so that all the reference numbers are currently recognised as text. Is
there an easy way to convert these to numbers? Presently I am having
to right click each cell individually and choosing 'Convert to number'

I am using Excel 2003.

Thanks in advance for your help.

Ket
London