220744/excel-formula-to-convert-number-to-both-feet-and-inches
If you want the answer to be accurate to the nearest inch, try this version. I see that Gary's Student's Answer will give you decimals in inches.
=INT(ROUND(A1*0.03937,0)/12)&"' "&MOD(ROUND(A1*0.03937,0),12)&""""
Using MS Excel (2010), I would like ...READ MORE
Assuming the first date in A2 try this formula ...READ MORE
"Times New Roman" typeface does not have ...READ MORE
We must parse the data because these ...READ MORE
Hello, yes u can find your birthdate using ...READ MORE
Hi To Calculate the date, we can ...READ MORE
1 I having a Excel sheet with 1 ...READ MORE
In this case, you can use nested ...READ MORE
Use the TEXT function to format, and ...READ MORE
You can combine some: For excel files - ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.