convert fixed number to text.
 

How do i assign a number to a text and use it in a sum formula...8=h?

convert fixed number to text.
 

do you want h + a to = i or 9?

"john" wrote:

How do i assign a number to a text and use it in a sum formula...8=h?

convert fixed number to text.
 

Hi,

Please provide more of an explanation, this is by no means clear.

=TEXT(A1,"@")

will convert the number in cell A1 to a text number.

But if you want to convert 1 to "One" then that is a whole different ball game

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"john" wrote:

How do i assign a number to a text and use it in a sum formula...8=h?