I have a list of data extracted from elsewhere and the dates are in USA
format
i.e. mm/dd/yyyy
Can excel swap this around to UK format dd/mm/yyyy ?
thanks in advance
--
Vass
................................................
Now: YZF-R1, CBR1100xx-x
Then: A100, MBX80, XL125, CB400, FZR600, CBR600Fv
Hi,
Format the dates to dd/mm/yyyy
Highlight the dates
Format > Cells > Number tab > Date > choose the one you need
If it is not in there go to Custom and put dd/mm/yyyy in the space provided under Type.
HTH.
Greg.
"The most overlooked advantage of owning a computer is that if they foul up there's no law against whacking them around a bit."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks