Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
import /paste -stop automatic conversion of text 05-12345 to date | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
insert date | Excel Worksheet Functions | |||
Automatic Date Entry | Excel Worksheet Functions |