Thread: How can i make numbers have text format without insering ' at each
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Numbers into text format in excel Numbers into text format in excel is offline
external usenet poster
  
Posts: 1
Default How can i make numbers have text format without insering ' at each
I have a file with 10000 numbers and I want them to be in "text" format. I do
the basics (format-cell-text) but only when I insert ' or edit the cell
(F2+ENTER)I have the right results. is there an easier way which is less time
consuming?
Reply With QuoteReply With Quote