Formatting number inside an & function

[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

 

[Vasant Nanavati]

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

etc.

You can probably remove the VALUE function with no problems.

 

[Bill Dedman]

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






.