Storing Data

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Seems like I'm storing my data as text - how can I store
it properly? Also, I have a column of sub-totals that I
want to get a grand total from. This column has numbers
as well as text in it. How can I add up the numbers?
 
Shouldn't matter, unless the numbers are text as well,
subtotal will ignore text

To convert text numbers to real numbers copy an empty cell
select the data, do edit>paste special and select add..
If that does not work you have invisible characters in the cells
 
Wendy,

Select the numeric cells, right click, choose Format Cells,
and format as numbers (to decimal as desired). A grand
total will sum excluding text in Excel XP, dont know about
older versions.
Col A

1
Q
2
3
Z
=sum(A1:A5) will equal 6
HTH
Kevin M
 
Back
Top