Hi all, Looking for some advice. I added VBA to my spreadsheet to enable Auto Capital letters, which works fine. In turn I have a Time Column, which is set to HH:MM, but when I input the time it defaults to scientific 2 decimals. I removed the VBA and the time works as normal. Added VBA again and the same Time error. Any ideas? Thanks JJSB