number trouble

[kevin]

Hi

I have a spreadsheet with a column that needs to be summed but it won't do it. if i go into the cell and press delete after the number then it becomes summable. its almost as if there are invisible characters after the number. any ideas on how i can fix this without editing each individual cell

thank
Kevin

 

[Frank Kabel]

Hi
try the following (as your numbers seems to be stored as string and
have a trailing space)
- use a helper column
- insert the following formula (if column A stores your values)
=--TRIM(A1)
- copy this down for all rows
- after this copy column B and insert it again with 'Edit - Paste
Special - Values'
- now you may delete column A

 

[Stefan Hägglund [MSFT]]

Hi Kevin!

Enter a "1" (without quotation marks) in an empty cell, then copy this cell.
Now select the cells with values, where the problem occur, and select Paste
Special from the Edit menu.
Select "Values" and "Multiply", then click OK.

Does this solve the problem?


Best regards

Stefan Hägglund
Microsoft Support

Hi,

I have a spreadsheet with a column that needs to be summed but it won't do

it. if i go into the cell and press delete after the number then it becomes
summable. its almost as if there are invisible characters after the number.
any ideas on how i can fix this without editing each individual cell?

 

[RagDyeR]

Try this:
<Data> <TextToColumns>,
<Next> <Next> <Finish>

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I have a spreadsheet with a column that needs to be summed but it won't do
it. if i go into the cell and press delete after the number then it becomes
summable. its almost as if there are invisible characters after the number.
any ideas on how i can fix this without editing each individual cell?

thanks
Kevin