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.
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)
Bookmarks