Here is the formula I'm using: ="Pay "&N12&" for "&O12
Column N is $
Column O is %
the current output is: Pay 4800000. for 0.35
im trying to achieve: Pay $4,800,000 for 35%
help?
Thank you in advance!
Here is the formula I'm using: ="Pay "&N12&" for "&O12
Column N is $
Column O is %
the current output is: Pay 4800000. for 0.35
im trying to achieve: Pay $4,800,000 for 35%
help?
Thank you in advance!
Try this (adjust refs, obviously)...
=TEXT(N9,"$0,000,000")&" and "&TEXT(O9,"0.00")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
="Pay "&TEXT(N12,"$#.00")&" for "&TEXT(O12,"0.00%")
Quang PT
Thank you! That worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks