Format as #,##0,

As I have posted before, my main "world" is the compiled version of VB and
in my 25+ years of programming BASIC and VB, I never saw that 'end with a
comma" trick... I just tried it in the compiled version of VB and it works
in the Format statement there (one comma truncates/rounds off the thousands,
two trailing commas truncates/rounds off the millions, and so on). Very
interesting. After all these years... still learning new things about an old
friend. Thanks for posting/emphasizing it.

By the way, that means there is another alternative for the OP's question...

=--TEXT(OtherSheetName!A1,"#,###,")

as a number (leave off the double minus signs for text).

Rick