Re: Really Shitty Impractical Security Advice..
I write a lot of additional functions, which take the data in cells and convert it.
For example we have a time analysis module that calculates hours, based on book-in and book-out times from an entry system. Excel though wants to round 24 hours into 1 day, so 96 hours shows as 0 hours. A simple VB function adds a formula to Excel which automatically formats the hours correctly.