Formatting number inside an & function

  • Thread starter Thread starter Bill Dedman
  • Start date Start date
B

Bill Dedman

Can you tell me how would I format the numbers, showing
commas for thousands, inside this formula?

="Average weekday circulation of " & VALUE(OFFSET
(diversity!S2,$B$2992-1,0)) & " ranks " & VALUE(OFFSET
(diversity!W2,$B$2992-1,0)) & " in the U.S."

That formula now returns:

Average weekday circulation of 8746 ranks 1500 in the U.S.


But I'm looking for

Average weekday circulation of 8,746 ranks 1,500 in the
U.S.

Thanks in advance for the help.

Bill
 
TEXT(VALUE(OFFSET(diversity!S2,$B$2992-1,0)),"#,##0")

etc.

You can probably remove the VALUE function with no problems.
 
Thanks!

-----Original Message-----
TEXT(VALUE(OFFSET(diversity!S2,$B$2992-1,0)),"#,##0")

etc.

You can probably remove the VALUE function with no problems.

--

Vasant






.
Click to expand...
 
Back
Top