I am pasting information from a scheduling program to a spreadsheet. In my example, please look at column Q. It seems that SOME negative values are erroring out with a #VALUE. Not all negative values, however. This is the weird part. I've tried both the 1904 fix and without. No avail. I can manually fix the error by changing the "=" to " ' ". But the point is we're trying to automate this report. Please advise if you need any other information and I will do my best to get it to you!
Bookmarks