PDA

View Full Version : EXCEL VBA: how to use vba fuction to translate the day format



kachun0102
10-31-2014, 12:58 AM
Hi all,
I have a question which is "How to use vba fuction to translate the day format from "dd/mm/yyyy" to yyyy/dd/mm" ?

Can anyone help me to solve the problem? Thank You! :bow:

Krishna Kumar
10-31-2014, 01:28 AM
format(Date, "yyyy/dd/mm")

Bob Phillips
10-31-2014, 04:52 AM
Or just set the numberformat


cell.NumberFormat = "yyyy/dd/mm"

Bob Phillips
10-31-2014, 04:52 AM
Or just set the numberformat


cell.NumberFormat = "yyyy/dd/mm"