LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35
Default Dates showing are not what I type

I am sorry if this is a stupid question but here goes .

If I type in dates as 010106 it gives me 01/09/27
This was raised in an earlier Question I tried the reply by Ragdyer which was
(If you were going to enter a *very* large number of dates into a column,
where you might consider it worthwhile using several *extra* steps in Text
To Columns (TTC), you could enter your dates using *6* digits (to avoid
ambiguity), *without* delimiters.

This entails a whole other procedure, so the saving wouldn't be realized
unless the number of dates to be entered was quite large.

For example, you could enter dates as mmddyy.
041705
121504
010105
101206
092504
122505

Then, select the cells, and
<Data <TextToColumns <Next <Next

Click on "Date", and make sure "MDY" shows in the window,
Then <Finish.

You've now made your 6 digit date entries recognizable to XL as *the* dates
that you want, not "morphed" into dates XL chooses.)

It did not work for me can someone please help me

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pre-1900 dates Richard Gadsden Excel Discussion (Misc queries) 1 March 26th 06 12:46 AM
Charts/ Graphs and Dates Trouble Heyna Charts and Charting in Excel 0 February 23rd 06 10:00 PM
Need to pull current dates from list w/many dates mcilpuf Excel Discussion (Misc queries) 4 February 20th 06 09:05 AM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 03:54 PM
Help with automatic dates foxx60 New Users to Excel 1 August 19th 05 06:01 PM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"