Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to paste in text like "01" from HTML table as text not numb
Format the cells as TEXT then past special as TEXT...
"JeffL" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to paste in text like "01" from HTML table as text not
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. "Sheeloo" wrote: Format the cells as TEXT then past special as TEXT... "JeffL" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to paste in text like "01" from HTML table as text not
You can then split it into columns by Data-Text to columns option and specify
the type for each column "JeffL" wrote: 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. "Sheeloo" wrote: Format the cells as TEXT then past special as TEXT... "JeffL" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Pasted values that paste as "number stored as text" | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |