| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No Auto date formate
Hi, When I copy numbers like 03-05 (which is the year range 2003-2005) to excel, it always automatically reformat that number to Mar-05. How can I just have it display as is without formatting to m/y? -- Lucent1698 ------------------------------------------------------------------------ Lucent1698's Profile: http://www.excelforum.com/member.php...o&userid=32543 View this thread: http://www.excelforum.com/showthread...hreadid=523303 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No Auto date formate
"Lucent1698" wrote
in message ... Hi, When I copy numbers like 03-05 (which is the year range 2003-2005) to excel, it always automatically reformat that number to Mar-05. How can I just have it display as is without formatting to m/y? Format the cells as text, then Paste Special/ Text -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| auto date script for 2 columns? have 1.. | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| Making a auto date entered into a cell permanent from a template | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Linear Mode
