The formula was "obviously" for the sum with the L removed........

--
Don Guillett
SalesAid Software

"J45on" wrote in message
...
I'm not sure which problem are u referring u. My level of expertise are
home
amature. It would be nice if u can tell me what i can type for the custom
format to be filled in the cell formating. But for the mean time i'll try
to
determine and test what ur trying to say.

what is crtl+shift+enter for? what is array? i copy rather than import.
There are certain things that i want that excel did not import for me. So
i
have to resort to manual copying that is by ctrl+C and ctrl+V from the
webpage to the spread sheet.

If it's too much of a hassle forget this thread and jus concentrate on my
1st two questions.

"Don Guillett" wrote:

on the import, try formatting before pasting

try this ARRAY formula which must be entered/edited with
ctrl+shift+enter

=SUM(VALUE(LEFT(H1:H2000,LEN(H1:H2000)-1)))

--
Don Guillett
SalesAid Software