Aug 20 2019 01:48 PM
I use an Excel Timer Activity IIF to upload time cards to Quickbooks. I recently started using numeric cost codes. The Timer Activity IIF spreadsheet will NOT save the cost code "01" - I have formatted "01" 5 possible ways, once I close this spreadsheet (saved) and reopen it, it always changes the "01" back to "1"
Aug 20 2019 01:52 PM
Custom format 00 shall work. I guess the code is number, not text.
Aug 20 2019 02:06 PM
Aug 20 2019 02:31 PM
@nikkifromtheblock , could you please submit small sample file - just one cell with the code will be enough.
Aug 20 2019 02:48 PM
Aug 20 2019 04:02 PM
Yes, the file, but few cells with code within it is enough. Of course, if you have no sensitive information you may attach your original file.
To attach click this icon at the bottom left corner of Reply window here and select your file.