Applescript to format a cell to date

[anode505]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to change a cell's format to date. How?

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to change a cell's format to date. How?

One way:

tell application "Microsoft Excel"
tell active cell
set number format to "dd mmm yyyy"
end tell
end tell

choose your favorite date format.