robinbernett
asked on
Use cell value to nearest whole number in concatenate function
I want to concatenate including using a cell that has a numberwith several decimal places. It is formatted to display as to the nearest whole number. In the concatenated return I also want it to be to the nearest whole number, but it is of course displaying all it's decimal places. How can I achieve this please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all.
I couldn't make the VALUE work, but ROUND, TEXT, and FIXED did - so problem solved, and with choice!
Much appreciated - i've often wondered.
I couldn't make the VALUE work, but ROUND, TEXT, and FIXED did - so problem solved, and with choice!
Much appreciated - i've often wondered.
ASKER
A wizard, and sage and a genius to my rescue! Very grateful as ever.
Put in C1:
=VALUE(CONCATENATE(A1,B1))
And make sure to format C1 as Number with 0 Decimal places.