/VBA/Excel vba date to string conversion

Excel vba date to string conversion

Excel formula to turn a date/time into text:

=TEXT(A1,"DD/MM/YYYY hh:mm:ss AM/PM")

'Reference:
'  https://support.office.com/en-us/article/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c

'---------------------------------------------------------------------------------------------

'VBA function to do the same thing:
Function DateToText$(dbl#)
    DateToText = Format(dbl, "DD/MM/YYYY hh:mm:ss AM/PM")
End Function

Source: academy.excelhero.com

Similar codes

5 votes164 views1 answer
Vba low word from Long Integer
VBA
-1 vote131 views1 answer
Vba code to add new column in table
VBA
1 vote152 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote133 views4 answers
Jwt token vb.net validation
VBA
3 votes160 views2 answers
Vba date to string
VBA
0 vote117 views1 answer
Find days in month vba
VBA
0 vote125 views1 answer
Vba copy paste value only
VBA
0 vote126 views2 answers
Get excel file from email attachment in vba
VBA
0 vote128 views1 answer
Vbscript abs
VBA
0 vote137 views1 answer
Show unix time in vba
VBA