Excel Cell Format

Scripting Forums AppleScript | Mac OS X
,
#1

Hello,

I have an Excel (2004) document that I am trying to import into another app of mine and am running into a small problem. I have two cells that have time in them
Ex.
Cell 1 = 12:55:00
Cell 2 = 14:00:00.

When I try to get the value of these cells they return a value of 0.538194444444 and 0.583333333333 respectively. The numbers returned are the numbers Excel would change the value of the cells to if I formatted the cells as General but cells aren’t formatted as general they are formatted as time. I am confused as to why the values are being returned like this.

This is the only code I am using at this point.

tell application "Microsoft Excel"
	tell window 1
		set SelectedCells to value of selection as list
	end tell
end tell

Any help would be great,
Thanks
Dallas

#2

Hi Dallas,

try string value


tell application "Microsoft Excel"
	tell window 1
		set SelectedCells to string value of selection as list
	end tell
end tell
#3

Perfect,

Thanks Stefan

Dallas