Thread: convert column from numbers to text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default convert column from numbers to text
As-is, with source numbers running in A1 down,
Put in B1: =A1&""
Copy down, then copy n paste special as values to overwrite col A. Clear col
B.
Reply With QuoteReply With Quote