# lovely height conversions

This topic is 7021 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Hey everyone,

first off. thank you. all your questions and answers have been a huge help in me getting my bearings on this program. you all are awesome...

my question -

i have a field for 'total height' in inches. and i just want to make a field that will convert it to X'Y

for instance...... they input 68 into the inches field. and the next field will say 5'8

any advice would be greatly appreciated.

thanks again.

##### Share on other sites

or instance...... they input 68 into the inches field. and the next field will say 5'8

Is not clear how 68 to 5'8. What formula you use?

##### Share on other sites

NumToText( Int( height / 12 ) ) & "'" & NumToText( Mod( height / 12 ) )

The NumToText() functions are probably a bit superfluous, but I like to be thorough. The "'" is a single quote surrounded by double quotes. " ' "

##### Share on other sites

Hi Vaughan,

I think you were misled by [color:"blue"]aaa version being 6, the original poster [color:"blue"]pensive is using v7. Your calculation was missing a comma behind the Height in the Mod Function

NumToText( Int( Height / 12 ) ) & "' " & NumToText(Mod(Height[color:"red"], 12)) & """"

For this to work for [color:"blue"]pensive I have modified it as follows:

GetAsText( Int( Height / 12 ) ) & "' " & GetAsText(Mod(Height; 12)) & """

HTH

Lee

##### Share on other sites

you guys are amazing. thank you all for the help.

it worked perfectly.

pensive...

##### Share on other sites

oh...so close. the only problem is it can't calculate a double digit for the second number.

ex. 60" = 5'0"

but if i put 71" = ?

because it can't write 5'11

or 5'10", 6'11" etc....

please if its not too much problem, can you straighten me out?

GetAsText( Int( height_in / 12 ) ) & "' " & GetAsText(Mod(height_in; 12)) & """

thanks again...

##### Share on other sites

ummm...yeah. nevermind.

good call. thanks.

##### Share on other sites

This topic is 7021 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account