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

%3CLINGO-SUB%20id%3D%22lingo-sub-621711%22%20slang%3D%22en-US%22%3EHow%20do%20I%20merge%20two%20currency%20cells%2C%20to%20create%20a%20range%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-621711%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20am%20hoping%20someone%20might%20be%20able%20to%20help%20me.%20I%20have%20two%20columns%20denoting%20currency%20eg%20E1%3D%240%2C%20F1%3D%2469%20(converted%20to%20single%20decimal).%20I%20am%20attempting%20to%20merge%20the%20two%20together%2C%20and%20create%20a%20range%20(%240-%2469).%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20used%20the%20concatenate%20function%2C%20but%20the%20result%20I%20get%20is%3A%200-%2468.814*******.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20to%20achieve%20the%20following%3A%3CBR%20%2F%3E%3CBR%20%2F%3E-%20numbers%20need%20to%20remain%20whole%20numbers%2C%20without%20decimals%20-%20both%20number%20values%20need%20to%20be%20expressed%20as%20%24%3CBR%20%2F%3E%3CBR%20%2F%3E-%20the%20%22-%22%20needs%20to%20be%20added%2C%20without%20a%20space%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anyone%20know%20of%20a%20formula%20that%20may%20help%3F%20OR%20-%20is%20there%20something%20I%20need%20to%20change%20in%20cell%20format%20to%20achieve%20the%20result%20I%20am%20looking%20for%3F%20Thanks%20in%20advance%20-%20any%20insight%20or%20assistance%20would%20be%20greatly%20appreciated.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-621711%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-621890%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20merge%20two%20currency%20cells%2C%20to%20create%20a%20range%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-621890%22%20slang%3D%22en-US%22%3EHi!%20Dont%20have%20an%20answer%20for%20tou%20but%20make%20sure%20too%20post%20this%20in%20the%20excel%20forum%20also!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-621899%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20merge%20two%20currency%20cells%2C%20to%20create%20a%20range%20in%20excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-621899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B-%20Thanks%20Adam.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted
Hi! Dont have an answer for tou but make sure too post this in the excel forum also!!
Highlighted