Default value in a cell

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

Is it possible to have a cell default to a value from a function but allowed
to be overwritten?

I want a cell to default to the current date but allow the user to overwrite
it with a different date.

Thanks
 
If you put
=today()
In the cell, the user can always just type over it.

=today() will change whenever the date changes. (It's not static.)
 
You must log in or register to reply here.

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

Conditional Formatting 1
Help with formula 1
Possible to select a string in a locked cell? 1
Default number format in Excel 1
How to enter start and end date/time in excel based on some specific value. 7
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Excel Can you lock the value of a cell but not the format? 1

Back
Top