ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Function for Date setting in specific format (https://www.excelbanter.com/excel-programming/435379-function-date-setting-specific-format.html)

johan

Function for Date setting in specific format
 
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


Per Jessen[_2_]

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




All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com