Decimal

L

lightbulb

I'm using a formula in column E that displays X in front of the number in
column B, and Y in front of the number in C. The issue is that some numbers
in B and C are decimals (2.36,10.01,101.75, etc.), but sometimes they are
whole numbers, 15,100,85, etc.). I need the data in column E to put a
decimal after the whole number, but no zeros...and I do not need another
decimal at the end of a decimal number...so basically if the number does not
already contain a decimal, I want it to put a decimal at the end....so if
column B read -140 and column C read 161.02...I want column E to read
"X-140.Y161.02"

Any help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top