Thank you so much Rick. This is just what I needed. You guessed correctly
that I did not want the time to recalculate as this is a list of balances at a
particular date and time. You nailed it even though I couldn't explain it!
Thanks.

"Rick Rothstein" wrote:

My guess is that you will not want the date or time to change once you have
entered them. Using the NOW and/or TODAY functions will not give you this
permanence. While not automatic, are you aware of the short cut keys to
enter the non-changeable date and time into a cell? To place the date, key
in Ctrl+; (the Control key coupled with the semi-colon key). To place the
time, key in Ctrl+Shift+; (the Control and Shift keys coupled with the
semi-colon key).

--
Rick (MVP - Excel)


"Carol G." <Carol wrote in message
...
I want to enter today's date in cell A and have the computer
automatically enter the current time (from the computer clock)
into cell B when cell A is filled in. I want the time to be 11:00 PM
format.

I am using Excel 2003 version