Help with date formatting please

[Shelly68]

I run reports off our payroll system to upload new members into Super.

Payroll gives dates like this

27/03/2009

how can I convert is to read 27-03-2009 this is how the Super fund wants it to be shown as


Many thanks in advance for any help

 

[Datsmart]

You can custom format it.

Select the Date Range you want to convert.
Hit Ctrl-1 to open Cell Format dialog box.
In the Number Tab, Select Custom
In the "Type" field input "dd-mm-yyyy" (without quotes)
OK

 

[Shelly68]

ah I love this site, found something on another thread,

thanks anyway