ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date programming (https://www.excelbanter.com/excel-worksheet-functions/65425-date-programming.html)

MeMe

Date programming
 
Is it possible to format a date to appear as 00/00/00 by only entering the 6
numbers and not the slashes?
--
T-Ray

JE McGimpsey

Date programming
 
See

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

In article ,
"MeMe" wrote:

Is it possible to format a date to appear as 00/00/00 by only entering the 6
numbers and not the slashes?


Gord Dibben

Date programming
 
MeMe

Not without using VBA code.

See Chip Pearson's site for methods.

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


Gord Dibben MS Excel MVP

On Mon, 16 Jan 2006 09:30:04 -0800, "MeMe"
wrote:

Is it possible to format a date to appear as 00/00/00 by only entering the 6
numbers and not the slashes?




All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com