Conversion keyword summary

Action	Keywords
ANSI value to string.	Chr
String to lowercase or uppercase.	Format, LCase, Ucase
Date to serial number.	DateSerial, DateValue
Decimal number to other bases.	Hex, Oct
Number to string.	Format, Str
One data type to another.	See the Data types summary.
Date to day, month, weekday, or year.	Day, Month, Weekday, Year
Time to hour, minute, or second.	Hour, Minute, Second
String to ASCII value.	Asc
String to number.	Val
Time to serial number.	TimeSerial, TimeValue

See also

• Keywords by task

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.