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

P

Pankaj

Hi

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



Thanks

Parminde
 
B

Bernard Liengme

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
 
R

Ragdyer

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
 
K

kcc

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
 
Top