Home

Excel Timer Activity IIF

%3CLINGO-SUB%20id%3D%22lingo-sub-813716%22%20slang%3D%22en-US%22%3EExcel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813716%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20an%20Excel%20Timer%20Activity%20IIF%20to%20upload%20time%20cards%20to%20Quickbooks.%20I%20recently%20started%20using%20numeric%20cost%20codes.%20The%20Timer%20Activity%20IIF%20spreadsheet%20will%20NOT%20save%20the%20cost%20code%20%2201%22%20-%20I%20have%20formatted%20%2201%22%205%20possible%20ways%2C%20once%20I%20close%20this%20spreadsheet%20(saved)%20and%20reopen%20it%2C%20it%20always%20changes%20the%20%2201%22%20back%20to%20%221%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-813716%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813730%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395451%22%20target%3D%22_blank%22%3E%40nikkifromtheblock%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECustom%20format%20%3CSTRONG%3E00%3C%2FSTRONG%3Eshall%20work.%20I%20guess%20the%20code%20is%20number%2C%20not%20text.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813766%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813766%22%20slang%3D%22en-US%22%3ESometimes%20it's%20the%20easy%20stuff%20that%20eludes%20me...thanks!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813783%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395451%22%20target%3D%22_blank%22%3E%40nikkifromtheblock%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813786%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813786%22%20slang%3D%22en-US%22%3EI%20spoke%20too%20soon.%20It%20won't%20save%20the%20formatting.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813824%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813824%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395451%22%20target%3D%22_blank%22%3E%40nikkifromtheblock%3C%2FA%3E%26nbsp%3B%2C%20could%20you%20please%20submit%20small%20sample%20file%20-%20just%20one%20cell%20with%20the%20code%20will%20be%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813838%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813838%22%20slang%3D%22en-US%22%3EI%20can't%20seem%20to%20figure%20out%20how%20to%20share%20one%20cell.%20Sorry.%20My%20first%20forum%20experience.%20I%20tried%20to%20attach%20the%20whole%20file%2C%20but%20it%20didn't%20like%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813945%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%20Timer%20Activity%20IIF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813945%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395451%22%20target%3D%22_blank%22%3E%40nikkifromtheblock%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20the%20file%2C%20but%20few%20cells%20with%20code%20within%20it%20is%20enough.%20Of%20course%2C%20if%20you%20have%20no%20sensitive%20information%20you%20may%20attach%20your%20original%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20attach%20click%20this%20icon%20at%20the%20bottom%20left%20corner%20of%20Reply%20window%20here%20and%20select%20your%20file.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20854px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127711i2A0BCD2DE3574D15%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
nikkifromtheblock
New Contributor

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"

7 Replies

@nikkifromtheblock 

Custom format 00 shall work. I guess the code is number, not text.

Sometimes it's the easy stuff that eludes me...thanks!

@nikkifromtheblock , you are welcome

I spoke too soon. It won't save the formatting.

@nikkifromtheblock , could you please submit small sample file - just one cell with the code will be enough.

I can't seem to figure out how to share one cell. Sorry. My first forum experience. I tried to attach the whole file, but it didn't like it.

@nikkifromtheblock 

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.

image.png

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies