Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal
Assuming your limit is up to 2 decimals:
="X"&TEXT(B2,"0.##")&"Y"&TEXT(C2,"0.##") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "lightbulb" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set automatic currancy decimal without entering the decimal? | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |