Worksheet Automatically Reverting Data Format
Good Afternoon All,
I'm having an odd issue, I have a spreadsheet I use to keep track of hours spent on working on client's website, for billing purposes.
You can see below that I've changed all the lines in the table to "Number" format with two decimals so the autosum functions work.
Here's the kicker: If you actually click on an individual cell, or save an reopen, anything like that...It reverts some (not all) of the cells to text format, and some to duration format...I have no idea why this change wont stick, and I need some help! It's seriously driving me insane! 😠
As you can see with just this one cell selected, it's reverted to "Text" format.
Help! 😟
MacBook Air (13-inch Mid 2013), OS X Mavericks (10.9)