when I enter my date it transfers

  • Thread starter Thread starter Zoe's Grams
  • Start date Start date
Z

Zoe's Grams

Is it possible to enter 010510 and have it post as 01/05/10 and is it
possible to enter 1330 and it post as 13:30? Thank you very much
 
Not without VBA or a formula to translate. You can't do it just with cell
formatting.
 
Yes.

But you need a macro.

Chip Pearson shares a couple here:
http://www.cpearson.com/excel/DateTimeEntry.htm

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

============
Or you could do your data entry and then use a helper cell(s):

for dates:
=--TEXT(A1,"00\-00\-00")
(format it as a date)

for times
=--(TEXT(A2,"00\:00\:\0\0"))
(format it as time)

13:30 means 1:30PM, right? Not 13.5 minutes after midnight...
 
Back
Top