automatic date value

J

Jakob Austgulen

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

David McRitchie

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

Format the cells as Text first.
 
G

Gord Dibben

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 Options>Disable Date Recognotion.


Gord Dibben MS Excel MVP
 
Top