How do I format a number in a cell containing mixed text and numbers (with or w/o a formula)?
For example, say B1 contains the formula ="Total invoiced = "&SUM(A1:A10) and the result is Total invoiced = 12345.98765
I specifically want the result formatted with 2 decimal places and a thousands (,000) separator so the result is Total invoiced = 12,345.98
TIA for any help.
Try this...
="Total invoiced = "&text(SUM(A1:A10),"#.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
formula = ="Total invoiced = "& text(SUM(A1:A10),"#,#.00")
Last edited by ikboy; 01-18-2016 at 11:40 PM.
Perfect! Thanks much.Originally Posted by ikboy
@FDibbins - yours is close, just missing the thousands separator.
oops missed the thousand sep, sorry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks