[Dba-office] Fwd: Interesting Excel problem

[Susan Harkins]

That's what I'm doing. I'm so grateful for you folks!

Susan H.

On Tue, Apr 11, 2017 at 1:23 PM, DJK Robinson <DJKR at msn.com> wrote:

> Just a thought, Susan - how about adding them?   B4 + D4
>
>
> John
>
> ________________________________
> From: Dba-office <dba-office-bounces at databaseadvisors.com> on behalf of
> Susan Harkins <ssharkins at gmail.com>
> Sent: 11 April 2017 17:11
> To: dba-office at databaseadvisors.com
> Subject: [Dba-office] Fwd: Interesting Excel problem
>
> Our animal care submits some weights in a strange format:
>
> pound;ounce
>
> So, the baby bobcat's weights might resemble 10;7, 14;3, 14;8, and so on.
>
> Parsing them is no problem. But, evaluating and returning poundage in
> decimal format is proving a challenge because I'm seeing something weird
> along the way. Specifically, regardless of how I concatenate the two
> values, I get unexpected results.
>
> I used Column To Text to parse the values using the ; character as the
> delimiter. Pounds are in column B, the ounce value is in column C. In
> column D, I use the formula:
>
> =C4/16
>
> to convert the ounce value into a decimal value.
>
> Here's where I run into trouble -- I've been unable to concatenate the
> pound integer and the results of that formula to return
>
> 10.4375
>
> 10 is the number of pounds; .4375 is 7 ounces, expressed as a decimal.
>
> It's impossible to put them together!
>
> I first tried
>
> =B4&D4
>
> which returns
>
> 100.4375
>
> instead of 10.4375.
>
> I've tried CONCATENATE(). I've tried working with a text value instead of
> the results of a formula. I've tried TRIM() and ABS() -- there's something
> going on that I clearly don't understand.
>
> There's probably an easier way to get what I need -- forest for the trees.
> But I don't understand why concatenating these two values -- whether value
> or text -- wants to add a 0 to the integer.
>
> Susan H.
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
> Dba-office Info Page - DataBase Advisors<http://
> databaseadvisors.com/mailman/listinfo/dba-office>
> databaseadvisors.com
> To see the collection of prior postings to the list, visit the Dba-office
> Archives. Using Dba-office: To post a message to all the list members, send
> ...
>
>
>
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office
>