Applescript to format a cell to date

A

anode505

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

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

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?
Click to expand...

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.
 
Top