making Excel 2007 show the "date"

		Excel Help Forum > Usenet Groups > Excel 2007 Help
making Excel 2007 show the "date"

Notices

Hi All,
The big green guy here, just wanted to let you all know that we now have the reputation system in place, the reputation system allows you to give a visible pat on the back to those that have helped you or whose information has been helpful.

You will see an icon in every post (Light Blue scales), click this to give the reputation point to whom you think deserves it, a green square appears for a reputation with more and more adding over time.Pretty soon you will see a string of green squares appear in the top right of your posts as your reputation grows and your forum presence!

Good Luck!
The Hulkster!

Thread Tools

Search this Thread

Display Modes

07-09-2008, 01:30 AM

THORmx

Registered User

Join Date: 07 Jul 2008

Location: us

Posts: 12

making Excel 2007 show the "date"

Hi,

I am having a hard time with this one. I can usually always get it to work in word, but have a helluva time working it into Excel.

I want it to display the current date, from the system, whenever I open the file. Problem is, when I hit "format" cell to show the one with the day (and the asterisk), it never does it. It will show the date I originally put in there.

Any ideas?

Thanks, and great forum

07-09-2008, 01:38 AM

shg

Forum Moderator

Join Date: 21 Jun 2007

Location: Dallas, Texas

Posts: 5,792

You could create a default template, Book.xls (stored in your XLSTART directory) with the formula =DATE() in a cell. You can also type Ctrl+; to enter the current date in a cell.

Quote:

Problem is, when I hit "format" cell to show the one with the day (and the asterisk), it never does it.

You've lost me on that.

Last edited by shg; 07-09-2008 at 01:41 AM.

07-09-2008, 04:59 AM

THORmx

Registered User

Join Date: 07 Jul 2008

Location: us

Posts: 12

Quote:

Originally Posted by shg

You could create a default template, Book.xls (stored in your XLSTART directory) with the formula =DATE() in a cell. You can also type Ctrl+; to enter the current date in a cell.

You've lost me on that.

I'm sorry I lost you. I'll try to explain a little more clearly. You know when you right click a cell, and click the option "FORMAT CELLS" and it gives you options such as "number, alignment, font, etc etc". Under the "NUMBER" option, you can choose "general, number, currency, accounting, DATE, etc". Well, I would choose "DATE" and then the second option, which has an asterisk (*) next to it. It says that it is supposed to change with system time, but doesn't.

Could you explain exactly how I'd enter that =DATE() thing? I already have a document going on, that I can't create a new default.

Also, great shortcut on entering the current date. I'm hoping I can figure this out.

Thanks for your help.

07-09-2008, 12:12 PM

shg

Forum Moderator

Join Date: 21 Jun 2007

Location: Dallas, Texas

Posts: 5,792

Quote:

Well, I would choose "DATE" and then the second option, which has an asterisk (*) next to it. It says that it is supposed to change with system time, but doesn't.

It doesn't say it changes with the system time, it says it changes with the operating system -- meaning the long and short date formats in your Control Panel regional settings.

=DATE() returns the current date

=NOW() returns the current date and time.

Both will change as the sheet is recalculated (DATE less often than NOW ...)

07-09-2008, 12:56 PM

royUK

Forums Administrator

Join Date: 18 Nov 2003

Location: Lincolnshire,UK

Posts: 6,552

I think you have totally confused SHG!

=TODAY() returns the date which is volatile, it will change automatically.

=DATE(1900,4,1) will return 1/4/1900

Date is a VBA Function to return the current date

__________________
Hope that helps.

RoyUK
--------
For Excel consulting, free examples and tutorials visit my site
Check out the free Excel Toolbar

New members please read & follow the Forum Rules

Where to copy the code to

Code Tags: Make your code easier for us to read

Last edited by royUK; 07-09-2008 at 01:02 PM.

07-09-2008, 01:22 PM

shg

Forum Moderator

Join Date: 21 Jun 2007

Location: Dallas, Texas

Posts: 5,792

Oops -- brain cramp!

Sorry, THOR, and thank you, Roy.

07-09-2008, 11:09 PM

THORmx

Registered User

Join Date: 07 Jul 2008

Location: us

Posts: 12

roy and shg, thanks for the help.

the today thing works great

07-10-2008, 12:42 AM

shg

Forum Moderator

Join Date: 21 Jun 2007

Location: Dallas, Texas

Posts: 5,792

Roy is always around when you need him most.

On behalf of Roy and me, you're welcome.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode