Thread: Trying to paste in text like "01" from HTML table as text not numb
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JeffL JeffL is offline
external usenet poster
  
Posts: 8
Default Trying to paste in text like "01" from HTML table as text not numb
I have a table I want to paste into excel. There are some codes likes like
"01", "01a", "01b", (quotes are not in html table). This should all be text,
but Excel keeps converting "01" to general format, and displaying as "1".
This is making it difficult to use pivot tables, and displaying correctly.
What can I do?
Reply With QuoteReply With Quote