Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste web without date format
When i paste from a web page, Excel 2007 automatically changes any text that
might be considered a date into date format. In the Excel help, it indicates that after pasting, a "format options" button should appear that gives you the choice of maintaining the original format. However, this button never appears. When pasting a large amount of data, it's not worth it to go in and re-type all of the cells that are formatted wrong. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste web without date format
The cells will only change if the spreadsheet is formated as General. You
can try to format the enire sheet as text before pasting the data. "tombugg55" wrote: When i paste from a web page, Excel 2007 automatically changes any text that might be considered a date into date format. In the Excel help, it indicates that after pasting, a "format options" button should appear that gives you the choice of maintaining the original format. However, this button never appears. When pasting a large amount of data, it's not worth it to go in and re-type all of the cells that are formatted wrong. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
Changing date format in copy paste | Excel Discussion (Misc queries) | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) |