I have an app that dumps time fields into Excel in format hh:mm. The problem is that the app can generate negative time e.g. -09:23. When dumped into Excel, Excel place a = sign in front and displays #VALUE!. If you click on the cell the value is displayed as =-9:23 but I cannot access the value programatically to change it to a text value. Is there any setting I can change or VBA code I can use? The app cannot be changed as it is vendor owned.

Can you format the cells to Text in advance, before you put time in to them?

Smiler44