Ask Your Question

Concatenate currency input with number and treat as currency

asked 2020-04-16 03:31:14 +0200

zf gravatar image

updated 2020-08-09 20:00:53 +0200

Alex Kemp gravatar image

Is it possible to concatenate currency input with number that is the result of a formula without relying on a intermediary cell? Example: cells have the format e.g. "$55 (26)" which means $55 due in 26 days. I just want to enter "55" and it should have the prefix $ and ideally be treated as a currency so I can sum up the dollar amounts of the cells. 26 days is the result of a formula returning a number.

What I'm looking for is $<user-input to be treated as currency> (<number output of formula>). I can have one column for the dollar amount and another column for number of dates, but grouping them in this context is more intuitive for me. Also just curious if this can be done.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-04-16 11:32:05 +0200

Opaque gravatar image

updated 2020-04-16 11:38:38 +0200


AFAIK you can't do that since you got no control on the input interpretation algorithm (and by the way: I'd consider your more intuitive approach as poor spreadsheet design). Have a separate column for currency, have an additional column for "due in" days and you may - for your personal preference - have a column showing everything in the way you want (using something like ="$" & A2 & " (" & B2 & ")" assuming that cell A2 contains the currency value and cell B2 contains the due-in-days value; B2 may be replaced by the calculation of due-in-days itself and this way saving extra column B).

edit flag offensive delete link more



... and the two adjacent cells might together look like what OP wants:

    A        B    
   $55     (26)
Mike Kaganski gravatar imageMike Kaganski ( 2020-04-16 14:46:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-16 03:31:14 +0200

Seen: 141 times

Last updated: Apr 16 '20