View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TimR TimR is offline
external usenet poster
 
Posts: 8
Default formatting cells with numbers as text

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