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

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

=TEXT(A1,"ddmmyy")
--
David Biddulph

"Maz" <(E-Mail Removed)> wrote in message
news:039077F3-4992-4EA8-B4AD-(E-Mail Removed)...
>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