Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Date Function formatting
Greetings,
TIA for any help I am using the Date function to return the current date to a text box on a user form. It arrives in "mm/dd/yyyy" format. How do I change the format, eg: "dd/mm/yy"? David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Date Function formatting
TextBox1.Value = Format(Date, "dd/mm/yy")
-- Dianne In , David typed: I am using the Date function to return the current date to a text box on a user form. It arrives in "mm/dd/yyyy" format. How do I change the format, eg: "dd/mm/yy"? David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |