formatting cells with numbers as text

[TimR]

Is there a way to bulk convert a standard number ( 1,233) to a "numbers as
text" format in an excel column. I can add the apostrophe to the cell...and
then add the comma to the resulting text/number...but I have a long column
with about 2000 numbers with comma that I must convert to the numbers as
text format with the little triangle in the upper left cell corner as
follows ( 1,234 )

Can this be done somehow thru formulas or mass cell formatting ?

Thanks, Tim R

 

[David Biddulph]

Depends a bit on what format you want to see the numbers in text.
Try =TEXT(A1,"#,##0")

 

[TimR]

Thanks David...I have been dancing around with this for almost two
hours...came close...but you had it perfect.

Thanks, Tim