|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 9th 04, 07:18 PM
|
|||
|
|||
Function to convert feet and inchs into decimal equivalents
I have several thousand cells of infomation in feet and inchs I need to be
able to do calculations on which I think I can only do by converting them into their decimal equivalents. Does anyone know a function or some other way to convert these? 
|
| Ads |
|
#2
December 9th 04, 08:09 PM
|
|||
|
|||
|
Hi
see: http://www.cpearson.com/excel/fractional.htm -- Regards Frank Kabel Frankfurt, Germany "Chuck Bierwirth" > schrieb im Newsbeitrag ... > I have several thousand cells of infomation in feet and inchs I need to be > able to do calculations on which I think I can only do by converting them > into their decimal equivalents. > > Does anyone know a function or some other way to convert these?
|
|
#3
December 9th 04, 09:43 PM
|
|||
|
|||
|
On Thu, 9 Dec 2004 11:18:46 -0800, Chuck Bierwirth
> wrote: >I have several thousand cells of infomation in feet and inchs I need to be >able to do calculations on which I think I can only do by converting them >into their decimal equivalents. > >Does anyone know a function or some other way to convert these? Exactly what is in the cells? --ron
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
