Hi friends,
I have a macro which v-lookup the date of births from another file. the issue what i am acing is when i am sharing my final file with different region, date format is changing. Is there any way to make the date value column in yyyy-mm-dd, irrespective of regional settings.
Below is the format which i currently have
>>> use code - tags <<<
Thanks
I have a macro which v-lookup the date of births from another file. the issue what i am acing is when i am sharing my final file with different region, date format is changing. Is there any way to make the date value column in yyyy-mm-dd, irrespective of regional settings.
Below is the format which i currently have
>>> use code - tags <<<
Code:
Columns("G:G").Select
Selection.NumberFormat = "[$-409]yyyy\-mm\-dd;@"
Thanks
Last edited by a moderator: