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

[Ben83]

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. 🙂

[#2]

Hi! Dont have an answer for tou but make sure too post this in the excel forum also!!

[#3]

@adam deltinger - Thanks Adam. 🙂

[#4]

@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