Well, all our computer systems just got upgraded, and I was pushed from Excel X to 2004 as a result. Now all my little scripts are having troubles.
Question: How do you now get the text value of a cell that is actually a number (time)?
The line I have now is…
set theStartTime to value of cell 4 of row EventCount
This sets theStartTime to a decimal number for the time, since that is what is stored in cell 4 of all rows of the sheet with which I’m working. How do I force that to give me the time in text?
Thanks for any and all help!
David Wilcox
Tech Director
Covenant Life Church