If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i format date to DDMMYY
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
how do i format date to DDMMYY
=TEXT(A1,"ddmmyy")
-- David Biddulph "Maz" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|