Hello all,
If I wanted to combine cell A1 "$10.00" with B1 "per day", how would I combine them so that the currency format would stay?
Currently I am using:
=CONCATENATE(A1," ",B1) but it is resulting in "10 per day". I'd like to keep the currency as well.
Thank you,
Scott
You can use the TEXT function:
=CONCATENATE(TEXT(A1,"$0")," ",B1)
Remember what the dormouse said
Feed your head
Try,
=CONCATENATE(TEXT(I10,"$ #.00")," ",J10)
I10 is amount and J10 per day
Or you can drop CONCATENATE function altogether
=TEXT(A1,"$0.00")&" "&B1
Row\Col per day $10.00 per day
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Excellent, thank you for the quick reply. For future reference @romperstomper, that works well as long as there are no decimals. I used yours in combination with @AlKey. Thank you all for your contributions.
Oops - I missed that you wanted the decimals!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks