View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Function for Date setting in specific format

Hi Johan

MyText = "Test: " & Format(Now(), "dd-mmm, hh:mm")

Regards,
Per

On 25 Okt., 07:10, johan wrote:
Hoi,

Can somebody help me out,

With my function I want to set a specific text + date/time format in a
field.
Like for example: *Test: 24-okt, 07:10

This is "text + the actual dd-mmm, hh:mm"

regards,
* *Johan