Enter date as DDMMYYYY

[myonlyb]

Hi,

I have to enter tons of dates into Excel. Currently I am using the
Date-Format for the Cells in the format DD.MM.YYYY
As I use the numeric block of the keyboard, it would be very much
easier to just enter DDMMYYYY instead, since I have to move the hand
for the dot...
I tried to use a custom cell format and entered DDMMYYYY as format.
When I enter e.g. 24.06.2006, I get an error (#########).

Does anyone know how to use my desired cell format? It would greatly
help me with the next thousand dates....

Thank you very much
Karl Ebener

 

[Roger Govier]

Hi
You could enter all of your dates down the column as24062006 without any
dots between.
When you have finishes data entry, mark the column>Data>Text to
columns>Next>Next>Date>D/M/Y>Finish
This will then convert the values to Excel dates.

 

[Ron de Bruin]

Check out also
http://www.rondebruin.nl/qde.htm

 

[Roger Govier]

Hi Ron

I don't know how I had missed that add-in on your site.
It's very neat.