MrExcel Publishing
Your One Stop for Excel Tips & Solutions

text and numbers


Posted by Paul B on January 19, 2001 11:13 AM

Is there any way to enter text and a number in one cell and still have excel add the sum of the cells? Example A1=5, A2=5, A3="T"5, A4= sumA1:A3 should be 15. Thanks Paul


Posted by Mark W. on January 19, 2001 11:49 AM

Not very easily -- if at all. May I ask why your
designing a worksheet that requires this function-
ality?

Posted by Loren on January 19, 2001 12:25 PM


Format cells - Custom - choose 0 (the 2nd choice). Edit it
with "A1" 0. That only gets you one format, so you have
to repeat for each number.

Posted by bigbob on January 23, 2001 9:10 AM

:Why not use the function N =N("some text in here")gives zero as an answer and can be added to a formula or number in a cell without affecting the numerical calculation.HTH.