Dear All,
we all know ctrl+; shoes today date, using dd/mm/yy format (my pc's format),
however in our office some pc's excel showing date mm/dd/yy format & some pc's excel showing dd/mm/yy format.
if i received data from other's pc where date format is mm/dd/yy then its change the date like: 03/04/22 become 04-Mar-22
how can i use/get the actual date.
TIA
Bookmarks