Enter date as DDMMYYYY

  • Thread starter Thread starter myonlyb
  • Start date Start date
M

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
 
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.
 
Back
Top