Forum Discussion

Ben83's avatar
Ben83
Copper Contributor
May 21, 2019

How do I merge two currency cells, to create a range in excel?

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. :)

excel
office 365
  • Jarodm's avatar
    Jarodm
    Copper Contributor
    Sep 11, 2024

    Ben83 

    To get the formatting of the second part, add the following to the end of the merge fields just before the closing brackets Myprice \# “$,0.00”

     

    Set your merge fields up as (Merge 1)-(Merge2)

    That should give you the $0-$68.81

     

     

     

     

Resources