Display text as date

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys :)
I use this formula =">="&DATEVALUE(Files!D3)+TIMEVALUE(Files!D3) to
display and use as filteroption.
(Dont ask why I have to do this exercise....)
However the formula works all right but the display appears as
decimalnumber in this text expression:

Actual displayed: >=40170,6145833333
Wanted displayed: >=23.12.2009 14:45:00

I KNOW that there is some way to transform the expression displayed,
but have not found anything useful on the web - so far.
Are there anybody called to give me a hand on this one?

Best regards Snoopy
(Wish you a Happy New Year as well)
 
I'm not sure if this will work with your filter, but you can change the display:

=">="&text(DATEVALUE(Files!D3)+TIMEVALUE(Files!D3),"dd.mm.yyyy hh:mm:ss")
 
I'm not sure if this will work with your filter, but you can change the display:

=">="&text(DATEVALUE(Files!D3)+TIMEVALUE(Files!D3),"dd.mm.yyyy  hh:mm:ss")









--

Dave Peterson– Skjul sitert tekst –

– Vis sitert tekst –
Click to expand...

Thanks Dave
I'll dive into this - there is some translation trouble; english vs
norwegian, to by-pass

Best Regards
Snoopy
 
Back
Top