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.
Problem handling negative time in Excel 2007
- Thread starter elliotgr
- Start date
