Thread
:
Are there any add-ins that lets a cell be formated or defined as a quantity with units?
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
Are there any add-ins that lets a cell be formated or defined as a quantity with units?
Excel already has this feature.
A1 has 4
B1 has 5
C1 has =A1*B1 which returns 20
Custom Format to 0"ft" and Alt + 0178
Gord Dibben MS Excel MVP
On 30 Apr 2007 15:28:51 -0700,
wrote:
It just occured to me that a really nice feature of Excel would be to
keep track of units if you wanted it to. It is part way there with
the CONVERT() function, but what I would envision would be to be able
formate a cell as a special kind of number that has units associated
with it. So when you take 2 cells with ft as units that it knows the
the resulting value has units of feet squared.
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben