slotguy87
New member
- Joined
- Oct 14, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Location
- Las Vegas, Nevada
- Excel Version(s)
- 2016
Hi,
I'm not a new user, but I cannot figure this out.
Every time I open Excel and choose a saved workbook to load, every sheet and all cells on every sheet are formatted to TIME. The cells are all supposed to be formatted to General, with a few formatted to Currency and one formatted to Long Date. I have recreated my project workbook several times but eventually, each one catches this TIME auto formatting 'infection'. When I recreate my workbook, I don't copy and paste anything from a previous workbook, I start over from scratch. The workbook has vlookup formulas in a lot of cells, but none have anything to do with time. This has been driving me nuts! Does anyone have any suggestions on what I should do to fix or stop this from happening? Even a bit of code to add to my project could help. I've been using Excel for 15+ years, but have only recently started attempting VBA.
Thank you for your help!
Andy
slotguy87
I'm not a new user, but I cannot figure this out.
Every time I open Excel and choose a saved workbook to load, every sheet and all cells on every sheet are formatted to TIME. The cells are all supposed to be formatted to General, with a few formatted to Currency and one formatted to Long Date. I have recreated my project workbook several times but eventually, each one catches this TIME auto formatting 'infection'. When I recreate my workbook, I don't copy and paste anything from a previous workbook, I start over from scratch. The workbook has vlookup formulas in a lot of cells, but none have anything to do with time. This has been driving me nuts! Does anyone have any suggestions on what I should do to fix or stop this from happening? Even a bit of code to add to my project could help. I've been using Excel for 15+ years, but have only recently started attempting VBA.
Thank you for your help!
Andy
slotguy87