a simple macro will do this automatically upon a click of a button otherwise
you are stuck with ctrl; ctrlshift;
--
paul
remove nospam for email addy!



"Ken Vo" wrote:

Thanks Paul,

What I really want is a formula in a command button to save the dates and
time that i have inspected a road. Whenever i open the same spread sheets,
the dates and time have changed. Can u help?

"paul" wrote:

copy and paste special =now() as a value or delete =Now() and
Insert a static date or time
Current date Select a cell and press CTRL+;

Current time Select a cell and press CTRL+SHIFT+;

Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;





--
paul
remove nospam for email addy!



"Ken Vo" wrote:

Hi,

I wonder if anyone can help me. I need to know how to create a command
button, when clicked it saves the spreadsheet along with the dates and time
on my desktop.

However, if that can't be done...is there a formula that lets u saves the
spreadsheet along with the dates and time. Whenever I open the same spread
sheet, the dates gets changed and my previous information of the dates are
lost - I use [= NOW()]. How can i stop this?