View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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