Hi guys,
I know this one is just a matter of custom formatting, which may not be too difficult to write a code, but here a challenge is that custom formatting code needs to match and apply different currency symbols.
It is all explained in excel file attached, would it be oka to ask you take a look into it, please?
Thank you...
https://www.excelforum.com/attachmen...1&d=1507042423
Managed to get this one out of the way
Could you explain how? I have been looking at your file for five minutes and can't understand what you need. You are talking about formatting as currency but have nothing in your file that looks like a number.Originally Posted by vill
But C3 is not formatted as currency.how do we format D3 so that cell would display text, but it is formated as a currency (same as C3)
Thanks for looking into Pls see file attached, where issue solved.
Only C7:D7 is formatted, then we adapted formulas in J3:J6 to get the desired outcome.
https://www.excelforum.com/attachmen...1&d=1507108586
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks