how do i format date to DDMMYY

M

Maz

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
 
O

OssieMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Date in Header 2
Doughnut Chart linked with the slicer in the pivot table 0
Convert text date to general number 6
Remove date format? 3
Default Value =Date$() in UK Date Format 5
date format 2
Mailmerge date fault!!! 3
Merge Fields Date Format 5

Top