How to store length in cell in British format (like INCHES)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pankaj - 08 Jan 2006 07:35 GMT

Hi

How I store 4'5'' (4 foot and 5 inches) in a cell and use it i
callculations.

Thanks

Parminde

Reply to this Message

Bernard Liengme - 08 Jan 2006 13:39 GMT

Your best method is to use a format like 4 5/12 with custom format # ??/12
BTW this is not longer British (UK is metric) but American

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi
>
[quoted text clipped - 4 lines]
>
> Parminder

Reply to this Message

Ragdyer - 08 Jan 2006 14:31 GMT

You can enter your numbers as fractions.
XL will automatically change the format of your cells to fractions, just
like it changes a cell format to date if you enter a number that resembles a
date.

'Number' <space> 'Fraction'
4 5/12

However, to keep the denominator a constant 12, you'll have to use a custom
format, such as:

# #/12

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>
> Hi
[quoted text clipped - 5 lines]
>
> Parminder

Reply to this Message

kcc - 09 Jan 2006 03:46 GMT

You could also type it in as text and to use it in calculations use
=LEFT(A1,FIND("'",A1)-1)+IF(ISERR(FIND(CHAR(34),A1)),0,MID(A1,FIND("'",A1)+1,FIND(CHAR(34),A1)-FIND("'",A1)-1)/12)
With the text (4'5") in A1.

Personally, I would just go with the fraction unless you already have a file
with lots of text entries.
kcc

> You can enter your numbers as fractions.
> XL will automatically change the format of your cells to fractions, just
[quoted text clipped - 23 lines]
>> View this thread:
>> http://www.excelforum.com/showthread.php?threadid=499137

Reply to this Message