May 20 2019 08:21 PM - edited May 20 2019 09:50 PM
Hi everyone, I am hoping someone might be able to help me. I have two columns denoting currency eg E1=$0, F1=$69 (converted to single decimal). I am attempting to merge the two together, and create a range ($0-$69).
I have used the concatenate function, but the result I get is: 0-$68.814*******.
I need to achieve the following:
- numbers need to remain whole numbers, without decimals - both number values need to be expressed as $
- the "-" needs to be added, without a space
Does anyone know of a formula that may help? OR - is there something I need to change in cell format to achieve the result I am looking for? Thanks in advance - any insight or assistance would be greatly appreciated. :)
May 20 2019 10:08 PM
May 20 2019 10:18 PM
@adam deltinger - Thanks Adam. :)