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

formatting cells with numbers as text
 

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

"TimR" wrote in message
...
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

formatting cells with numbers as text
 

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

Thanks, Tim

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Depends a bit on what format you want to see the numbers in text.
Try =TEXT(A1,"#,##0")
--
David Biddulph

"TimR" wrote in message
...
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