Re: Inserting the "DAY" ?

Article View: comp.databases.ms-access

Article #62

Back to comp.databases.ms-access Previous Next

#62

From: Tim Blatch
Date: Wed, 24 Jul 1996 00:00

15 lines
966 bytes

I. C. wrote:
> Is there a way of inserting the DAY into an Excel spreadsheet together
> with the full date?
> 
> eg.  Wednesday, 24 July, 1996

Fistly type <CTRL> + ;   this puts today's date in the cell
then go to Format Cell, select the number tag, go down to date format.

type in the code box "dddd dd/mm/yy"

Good Luck

Tim Blatch

Technical Details

Message-ID: <31F5B37E.679D@ozemail.com.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <4t4c12$dr0@corolla.onthenet.com.au>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,b660f93ac2223217
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 108c83,b660f93ac2223217
X-Google-Attributes: gid108c83,public
From: Tim Blatch <auftim@ozemail.com.au>
Subject: Re: Inserting the "DAY" ?
Date: 1996/07/24
Message-ID: <31F5B37E.679D@ozemail.com.au>
X-Deja-AN: 170650125
references: <4t4c12$dr0@corolla.onthenet.com.au>
content-type: text/plain; charset=us-ascii
organization: Australian Ultralight Federation
mime-version: 1.0
newsgroups: comp.databases.ms-access,aus.computers
x-mailer: Mozilla 3.0b5a (Win95; I)

Reply to Parent Message