automatic date value
 

When I copy/ paste values from internet, sometimes the value is inserted as
a date value.
Is it possible to turn this off?

--


Jakob

automatic date value
 

"Jakob Austgulen" wrote ...
When I copy/ paste values from internet, sometimes the value is inserted as
a date value.
Is it possible to turn this off?

Format the cells as Text first.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

automatic date value
 

Can you bring the data in as the result of a Web Query?

You can specify in the query to treat numbers as numbers and not as dates.

Under Web Query OptionsDisable Date Recognotion.


Gord Dibben MS Excel MVP

On Mon, 12 Feb 2007 15:16:18 +0100, "Jakob Austgulen" wrote:

When I copy/ paste values from internet, sometimes the value is inserted as
a date value.
Is it possible to turn this off?