Pasting # excel formats in date not # format

Microsoft Excel 2007
August 12, 2009 at 10:42:05
Specs: Windows XP
When I paste numbers I've copied from the web
into excel 2007, they are converted into date
format.

Is there a way to prevent this conversion & keep
them as text or numbers?


See More: Pasting # excel formats in date not # format

Report •


#1
August 12, 2009 at 10:56:30
Try some of the different options available under Edit...Paste Special, such as Text.

If they then need to be converted to numbers, come on back and maybe we can offer some tips.


Report •
Related Solutions


Ask Question