import number data doesn't allow summing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing a txt file. one of the columns contains numbers. After import, I am unable to sum or perform any number manipulation. I'd appreciate any help

Thanks
Craig
 
Hi Craig
probably the numbers are stored as text format. Try the following:
1. Format the column as number/general (goto 'Format - Cells')
2. Enter a 1 in an empty cell, select this cell and copy this cell
(CTRL+C)
3. Select the column with your numbers and goto 'Edit - Paste Special'.
Select the action 'Multiply'

That should work
Frank
 
Thank you for the quick reply and yes, I believe that it works. (I'm just seeing the formula in the cell that I've targeted to hold the results from a summing. (the cell looks like =sum(c1:c120) ) )
 
Hi Craig,
if you only see the formula text then you have to format this formula
cell with 'general' and re-enter the formula (or click in the formula
bar for this cell and hit ENTER - only reformating is not enough)

HTH
 
Thank you for your offer to help. Unfortunately the paste special doesn't change the text to number.
 
Back
Top