Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data changes to date format
Hi all, sorry if i'm repeating something that has allready been covered but I can't find it anywhere on the forums. I've got a problem with excel automatically changing numbers that I cut and paste from the web into date's For example the the data in a cell may be "5/2" and I want it to remain as this but excel thinks it's a date and changes it to "5-Feb" (Another example would be "10/11" being changed to "10-Nov") I can't change the format of the source data as this is cut and paste directly from a web page, is there anything I can do to turn off this auto format feature? Thanks -- keybrook ------------------------------------------------------------------------ keybrook's Profile: http://www.excelforum.com/member.php...o&userid=31353 View this thread: http://www.excelforum.com/showthread...hreadid=510495 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data changes to date format
Format the cells as Text
Paste Special as Text instead of the standard Paste. -- Rob van Gelder - http://www.vangelder.co.nz/ "keybrook" wrote in message ... Hi all, sorry if i'm repeating something that has allready been covered but I can't find it anywhere on the forums. I've got a problem with excel automatically changing numbers that I cut and paste from the web into date's For example the the data in a cell may be "5/2" and I want it to remain as this but excel thinks it's a date and changes it to "5-Feb" (Another example would be "10/11" being changed to "10-Nov") I can't change the format of the source data as this is cut and paste directly from a web page, is there anything I can do to turn off this auto format feature? Thanks -- keybrook ------------------------------------------------------------------------ keybrook's Profile: http://www.excelforum.com/member.php...o&userid=31353 View this thread: http://www.excelforum.com/showthread...hreadid=510495 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
Convert data into standard military time format | Excel Discussion (Misc queries) | |||
Excel, want to change date format from us to uk, for old data. | Excel Discussion (Misc queries) | |||
Date Format Problems?? | Excel Discussion (Misc queries) | |||
How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) |