Get instant live expert help on how to convert int to string

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need to convert 41:30hrs to a digital form. This formula only works up to 24hrs =(A2-INT(A2))*24 Many thanks
Solved by B. U. in 27 mins
I wanted to convert a value from centimeters to Inches and Feet. in the following format (0' 00'') and I am using the following forumla for this =INT(CONVERT(A1,"cm","ft")) & " '" & 12*(CONVERT(A1,"cm","ft")-INT(CONVERT(A1,"cm","ft"))) & """" The answer is accurate but the only Problem is The value of Inches has a lot of digits after decimal points.. Please help me how can I round off the Inches part of the value to two digits after decimal point? Please help me how can I improvise this formula Thanks Saram.
Solved by C. F. in 23 mins
I need a formula to convert a string of letters within a cell to numbers - abcdef to 123456
Solved by B. A. in 28 mins
I tried to convert a value into date but excel gave me a unique string referencing months and years instead.
Solved by V. B. in 19 mins
I need to convert a string of letters, example "NEEGVQE" which all in one cell and convert each letter into a number, example N= -3.5 E= -3.5 G= -0.4 V= 4.2 Q= -3.5 and then add those numbers up to get a value.
Solved by V. U. in 25 mins