Today I discovered something quite by accident, but it is a hack worth knowing. There have been many times when working in a Google Spreadsheet that I have dealt with numbers and dates that I want to display as I type them. I don't want it to auto-format the date to standard, nor drop the 0 on the front end of a number that needs it to display. There is a HACK to do this! Did you know that??