how do i format date to DDMMYY

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
 
G

Guest

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

Convert text date to general number 6
date format 2
Format Date in Header 2
text and date format in a cell 4
Mailmerge date fault!!! 3
Exporting Data to Excel-Date Format Changed 3
Default Value =Date$() in UK Date Format 5
Remove date format? 3

Top