paste web without date format

T

tombugg55

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

Joel

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.
 

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

Remove date format? 3
Excel 2002 : Anway to paste without time values ? 3
date format will not change in Excel 3
Puzzled about javascript interfering with functions and formatting 4
format text to date results in ############## 4
Changing date format in copy paste 2
Date Format Glitch 5
Formatting not protected when paste 7

Top