date and time

[ladimples247]

I need some help. I'm trying to put a formula in a cell to ready onl
the date. When i set the date and type in 02162005 it gives me a dat
for 5/14/19. how can I fix it for it to show todays date in that on
cell. Yeah i can use control, ; but i have multiple users and don
know that much of excel. so im trying to set it up for when they typ
in the date it would appear todays date or the date they want to use.
for example I want today's date 02162005 to appear as 2/16/2005 in th
cell. Help please !!!!!!!! :confused

 

[Nick Hodge]

you need to understand how excel treat dates and times to understand what is
happening. Without code what you want cannot be done

To understand dates/times and for the code to fix what you want, check here

www.cpearson.com/excel/datetime.htm


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Peo Sjoblom]

You can't type in a number and expect excel to know it's a date, you need to
either use a date delimiter like / or -
or else you need to use code that will take your number and make it into a
date

http://www.cpearson.com/excel/DateTimeEntry.htm