convert fixed number to text.

[john]

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

 

[dlw]

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

 

[Shane Devenshire]

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