Autosum mixed text and numbers returns zero

[myboy]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi there, I imported a csv file containing a column of mixed text and numbers. (eg row 1 = AUD 2.55, row 2 = AUD 3.64 etc). when I use autosum, it returns zero. I have to remove the text (AUD) in order to have the calculation return a value. Is there any way to have autosum do the calc without physically removing the text?

Thanks for your help.

 

[JE McGimpsey]

Hi there, I imported a csv file containing a column of mixed text and
numbers. (eg row 1 = AUD 2.55, row 2 = AUD 3.64 etc). when I use autosum, it
returns zero. I have to remove the text (AUD) in order to have the
calculation return a value. Is there any way to have autosum do the calc
without physically removing the text?

No. Sum only works on numbers.

If your entries are in a column, use Data/Text to columns to separate
the text from the numbers.

 

[myboy]

Thanks Mr Mac, very helpful!