how do i format date to DDMMYY
Hi Maz,
Is it actually converting existing dates in your worksheet?
The reason that I ask this is because even though you format the cells to
ddmmyy, when actually entering a date in the formula bar you still have to
include the / delimiter.
Example if formatted as ddmmyy and you enter 230807 then it changes to
041231. If you enter it as 23/8/07 then it will reformat to 230807.
Regards,
OssieMac
"Maz" wrote:
I am setting up an excel sheet to export journal entries to Syspro, the date
column must be DDMMYY, if i go through format cells and custom DDMMYY, when I
enter the date it changes it to its numeric value. Syspro needs excel to
show the date as 220807. Please help. Many thanks
|