Date Formatting

P

Parry

Is there a way to propogate the current date into a cell
with just one key stroke?
 
M

Mathew P Bennett

Hi
Quick attempt, though I am sure you will get more detailed responses in due
course.
Assign a short cut key for a macro using the =Today() function, and format
as required
NB. will apply to active cell.
Mathew
 
C

Chip Pearson

Parry,

CTRL+; will insert the current date. CTLR+SHIFT+: will insert the
current time. These are entered as static text, meaning the values
will not update in the future.



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
how to copy a formula to other cells-any shortcut 5
Macro for data and time 3
Formatting templates 7
Excel does not accept text format! 0
Can i upgrade Office 2019 professional plus to office 2021 professional plus? 1
Send meeting request for different dates (no repetition) to different people 0
Display weeks from a Milestone 0

Top