Get current date in yyyymmdd hh:mm:ss format?

[shawnh]

Hi all, does anyone know if there's a command (or workaround) to get the current date/time in the format yyyymmdd hh:mm:ss?

Thanks!
Shawn

[DonkeyOte]

See NOW() function

You can use a Custom Format as you describe on the cell containing the function, or use the TEXT function if you prefer as a literal string.

=TEXT(NOW(),"yyyymmdd hh:mm:ss")

[JimmyA]

Hello There

if you put the formula =NOW()

and the format the cell to custom format yyyymmdd hh:mm:ss

that should work

hope this helps

Jim

[shawnh]

DonkeyOte ("DonQuixote"... cute!), that's perfect, just what I was looking for, thanks.

Thanks too JimmyA!

Cheers
Shawn