formatting cells with numbers as text

  • Thread starter Thread starter TimR
  • Start date Start date
T

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
 
Depends a bit on what format you want to see the numbers in text.
Try =TEXT(A1,"#,##0")
 
Thanks David...I have been dancing around with this for almost two
hours...came close...but you had it perfect.

Thanks, Tim
 
Back
Top