Trying to paste in text like "01" from HTML table as text not numb

J

JeffL

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?
 
J

JeffL

I need the data to save in separate columns, as it is in the table. When I
paste as text, it ends up in one column, which is worse.
 
S

Sheeloo

You can then split it into columns by Data->Text to columns option and specify
the type for each column
 

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

Similar Threads

Is Paste Special HTML broken in Excel/Office 2007? 1
Excel changes 01-6601(text field) to Jan-01 when copy/paste 4
TEXT(F2 "0,0") displays 1 as 01, & how to bold and underline in TE 2
Paste from Word table into Excel 6
Formatting Numbers to Text or??!!! 6
Grouping Dates in Excel 2007 Pivot Tables 1
Excel 2007 and Paste Special with HTML and data from the web 3
Text to Columns not working correctly with dates in Excel 2007 5

Top