Prev: Using Select Case on Single column only
Next: Problems with ACE OLEDB provider
From: JIMIMJ on 21 May 2010 14:43
I need a formula to calulate a individuals within a group weight loss. When
I use the . it only calcualtes to 10.
From: Dave Peterson on 21 May 2010 14:57
I'd use two columns -- one for the pounds and one for the ounces.

Or enter the weights like:

127 15/16
(for 127 pounds and 15 ounces)

Give it a nice format (Format|cell|fraction)
or even a custom format of:
##0 ??/16





JIMIMJ wrote:
>
> I need a formula to calulate a individuals within a group weight loss. When
> I use the . it only calcualtes to 10.

--

Dave Peterson
From: Rick Rothstein on 21 May 2010 15:01
When you use what "." and what is "it" that only calculates to 10? You
should probably tell us a little more about what you have and what you want
afterwards (examples would help).

--
Rick (MVP - Excel)



"JIMIMJ" <JIMIMJ(a)discussions.microsoft.com> wrote in message
news:83544BA6-D6C2-40AB-BAB1-C541886CF6D1(a)microsoft.com...
> I need a formula to calulate a individuals within a group weight loss.
> When
> I use the . it only calcualtes to 10.

 | 
Pages: 1
Prev: Using Select Case on Single column only
Next: Problems with ACE OLEDB provider