I have a column of cells with numbers like 5.10, 4.10, and whole integers
like 60,65,70,etc. the whole numbers are in inches and the fractions are in
feet and inches like 5feet and ten inches. If I want all the numbers to
appear in inches format in the next column ,what formula do I apply.That is
the values inches should remain as they are and the values in feet should be
converted into inches and displayed. The feet measurements are below 9 feet
in value.
any help in this regard will be appreciated very much.
thank you guys and have a nice day
steve

On Mon, 7 Aug 2006 12:02:53 -0700, steve
wrote:

I have a column of cells with numbers like 5.10, 4.10, and whole integers
like 60,65,70,etc. the whole numbers are in inches and the fractions are in
feet and inches like 5feet and ten inches. If I want all the numbers to
appear in inches format in the next column ,what formula do I apply.That is
the values inches should remain as they are and the values in feet should be
converted into inches and displayed. The feet measurements are below 9 feet
in value.
any help in this regard will be appreciated very much.
thank you guys and have a nice day
steve

If you happen to have the Analysis ToolPak installed, you could use:

=IF(A1=INT(A1),A1,DOLLARDE(A1,12)*12)

otherwise

=IF(A1=INT(A1),A1,INT(A1)*12+MOD(A1,1)*100)


--ron

Ron,

Your system clock seems to be off by a day. Please fix it.

On 7 Aug 2006 20:26:36 -0700, "Harlan Grove" wrote:

Ron,

Your system clock seems to be off by a day. Please fix it.

Yes, someone pointed that out to me yesterday. I don't know how it got changed
but it seems to be OK now (since I corrected it last night). I'll have to keep
a closer eye on it.


--ron