ExcelBanter - Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Dates (https://www.excelbanter.com/excel-worksheet-functions/164283-dates.html)

Frances C[_2_]

Dates

What can i do to enter a date with out the dash into a cell, and be the date
that I want and not something different.

JE McGimpsey

Dates

See

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

In article ,
Frances C wrote:

What can i do to enter a date with out the dash into a cell, and be the date
that I want and not something different.

Gary''s Student

Dates

Dashes and slashes are not needed to enter a date. Click on a cell and enter:

31 October 2007
--
Gary''s Student - gsnu200752

"Frances C" wrote:

What can i do to enter a date with out the dash into a cell, and be the date
that I want and not something different.

All times are GMT +1. The time now is 09:55 AM.