Formatting # in one cell

B

Brent

Can I separate numbers by a comma within a single cell so
I can add, average and use the pivot function calculating
each number separtly? I have the column formatted as
text.

In the cells I have: 2, 3, 4, 5
12, 2, 5, 24

There is one cell per row with the numbers and one column
with these numbers.
Thank you for your help.
[email protected]
 
B

Bernie Deitrick

Brent,

You'll have to use Data | Text to columns, prior to doing anything with your
numbers - as they are, Excel will treat them as strings.

HTH,
Bernie
MS Excel MVP
 
Top