View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default ="my text" &TODAY()

The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever.
What I want is:
Logged today - 03/Jul but what I get is Logged today - 39267

Answers on a postcard please...

--
tia

Jock