how do i format date to DDMMYY

Giganews Newsgroups
Subject: how do i format date to DDMMYY
Posted by:  MAZ
Date: Thu, 23 Aug 2007

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

Replies