how do i format date to DDMMYY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top