Date in Cell

[ExcelConfussed]

Is it possible only the display the date in a cell when you select the
cell. Eg A1=NOW() I only want the date to displayed when you select
cell A1? Any ideas

 

[Harlan Grove]

Is it possible only the display the date in a cell when you select the
cell. Eg A1=NOW() I only want the date to displayed when you select
cell A1? Any ideas

Yes, it's possible using a lot of event handlers, but it'd be VERY cumbersome
and rather fragile. Do you really need this functionality? What benefits do you
believe it would provide? I ask because there's almost certainly a better way to
provide the benefits you seek than how you're proposing to accomplish them.

 

[Gerrit-Jan Linker]

Hi Frans,

You could use a format to only display the date part of the date time
information.

Actually I have created 2 functions for you in our LITlib functions
library:
DateNow and TimeNow

DateNow() will return the current date without time information.
TimeNow() will only return the current time without date information.
Complementing that with the Now() function you have all the options
you need I think.

Have a look at LITlib at www.oraxcel.com
Specifically please have a look at www.oraxcel.com/projects/litlib

Is it possible only the display the date in a cell when you select the
cell. Eg A1=NOW() I only want the date to displayed when you select
cell A1? Any ideas

Best regards, Gerrit-Jan Linker
www.oraxcel.com