Autosum mixed text and numbers returns zero

M

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.
 
J

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?
Click to expand...

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.
 
Top