Subtotal function (again)
 

I figured out why my totals weren't coming up. The column that the numbers
are in are text. How can I convert a text column into a numeric one? I
tried hilighting the column and formatting the cells, but that didn't change
anything. I can tell because textual values automatically go to the left of
a cell and numeric values are to the right. Is there a formula I can add to
a new column to convert them?

Thanks again!
Kyli

Hi
try:
- copy an empty cell
- select the values
- Goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany
"Kyli" schrieb im Newsbeitrag
...
I figured out why my totals weren't coming up. The column that the numbers
are in are text. How can I convert a text column into a numeric one? I
tried hilighting the column and formatting the cells, but that didn't
change
anything. I can tell because textual values automatically go to the left
of
a cell and numeric values are to the right. Is there a formula I can add
to
a new column to convert them?

Thanks again!
Kyli

Numeric will go to which ever side you want. Formatting "accounting" goes to
the right.

"Kyli" wrote:

I figured out why my totals weren't coming up. The column that the numbers
are in are text. How can I convert a text column into a numeric one? I
tried hilighting the column and formatting the cells, but that didn't change
anything. I can tell because textual values automatically go to the left of
a cell and numeric values are to the right. Is there a formula I can add to
a new column to convert them?

Thanks again!
Kyli