How do i assign a number to a text and use it in a sum formula...8=h?
S Shane Devenshire Jan 30, 2009 #3 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
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
