formatting cells with numbers as text

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
 
D

David Biddulph

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

TimR

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

Thanks, Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top