Formulas . paste linked and Sum

[gkmickel]

I have created a column of numbers in cells that I have copied and paste linked into each cell from another sheet. I would like to now add up these cells and it will not add them. How do I get the sum formula to read these cells as values so it will add them?

thank you 

[#2]

Hi @gkmickel 

If you can post a sample of the file that would be great.

If the "numbers" are actually text you could refer to them within a VALUE function to convert  so   =VALUE(A1) + VALUE(A2)

[#3]

THANK YOU @Wyn Hopkins this work perfectly 

[#4]

@gkmickel 

As a comment

=1 + 2              returns 3
="1" + "2"          returns 3
=SUM("1","2")       returns 0
=SUM(--"1",--"2")   returns 3
=SUM(VALUE("1"),VALUE("2"))   returns 3