Excel Autoformating cells
You could try Paste SpecialText
Or copy into Notepad, save then open with Excel to get the Text to Column Wizard
where in Step 3 you choose Text as Column Data Format.
Gord Dibben MS Excel MVP
On Wed, 9 Jul 2008 01:41:01 -0700, Piglet
wrote:
Is it possible to stop excel from Auto formatting a cell into date fprmat
when you paste date in from the internet?
|