View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Hopkins Gary Hopkins is offline
external usenet poster
 
Posts: 4
Default Convert numbers to text

Hi, how can I convert a number in a cell to a text value?

Normally I would just edit my cell and put an apostrophe in front of the
number to make it a text cell, however I don't see doing this to 1000+ rows
as something very fun and I'm sure there must be a different way of doing
this.. ?

Thanks

Gary