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!
EXCEL VBA: how to use vba fuction to translate the day format
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!
format(Date, "yyyy/dd/mm")
________________
Kris
Or just set the numberformat
cell.NumberFormat = "yyyy/dd/mm"
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Or just set the numberformat
cell.NumberFormat = "yyyy/dd/mm"
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
