Get instant live expert help on convert formula to value

“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

how to convert to value using formula inside conditional formatting
Solved by A. J. in 20 mins
i want to convert 1'-6" to decimal value
Solved by K. U. in 25 mins
how to 0.20.50 to convert 0.2050 in this value please tell
Solved by E. J. in 22 mins
I need a formula that will take any negative value in one cell and convert it to positive 100 in another cell
Solved by X. H. in 26 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 to round off in excel 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