auto dates?

[just1creation]

hello,
is it possible to have column A to automatically insert a date when you enter something in column B?
for an example:
i enter an account number in column B... then in column A will have the date that i entered that account number.

[oldchippy]

hello,
is it possible to have column A to automatically insert a date when you enter something in column B?
for an example:
i enter an account number in column B... then in column A will have the date that i entered that account number.

Hi just1creation,

You could have a formula like this,

=IF(B1="","",TODAY())

this would put today's date in cell A1, but you would then have to Copy > Paste Special > Values to fix the date, but this seems a long way round.

The other quick way to enter a date is Ctrl+;, this is then fixed

oldchippy

[just1creation]

hey that works great! my other problem is the next day i will need to enter more accounts, but when i do it enters the date but it changes all the dates from the previous rows. i need the previous dates not to change.