| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates automatically formatted wrong
Hi. I'm copying dates and other data from a text file which has them formatted like: YYYY-MM-DD and excel reformats them as soon as i copy them into a format like: dd/mm/yyyy taking away zeros where they are not needed. is there any way for me to copy and paste the dates and keep them looking exactly the same. thanks! -- bigajosepi ------------------------------------------------------------------------ bigajosepi's Profile: http://www.excelforum.com/member.php...o&userid=37838 View this thread: http://www.excelforum.com/showthread...hreadid=573940 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates automatically formatted wrong
got it. gotta use open to open a text file -- bigajosepi ------------------------------------------------------------------------ bigajosepi's Profile: http://www.excelforum.com/member.php...o&userid=37838 View this thread: http://www.excelforum.com/showthread...hreadid=573940 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| US dates to UK?? | Excel Worksheet Functions | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| How do I automatically generate dates? | Excel Discussion (Misc queries) | |||
| Excel shifts to wrong worksheet automatically | Excel Worksheet Functions | |||
| In Excel spreadsheeet the dates change to the wrong date after we. | Excel Discussion (Misc queries) | |||
Linear Mode
