setting a default value for cells

  • Thread starter Thread starter Shaun
  • Start date Start date
Shaun
What do you mean by "default value"? If you enter 3 in the cell, and save the sheet, then it will always have a 3 when it is opened

If you want three to be a minimum value you can do this with Data Validatio

Data>Validation>Setting

Allow: Decima
Data: greater than or equal t
Minimum:

Good Luck
Mark Graesse
(e-mail address removed)

----- Shaun wrote: ----

how do make a cell set a default value of say 3
 
I think what Shaun meant is something like in a form (say distributed to users of a survey - like in my case) - I need to figure out how to default certain fields to certain values. It would be nice if a user pops open the excel form survey and in the date field for example, today's date is already defaulted for them, so they do not have to enter it in the field. Obviously, other fields could have more specific defaults.

How do you force certain fields or controls to default to certain hardcoded (e.g. State = TX) or non-hardcoded (as in today's date using the today function) values?
 
Back
Top