Forum Discussion
Small business
I'm using Exel 365. I've started a small business and doing the bookkeeping. I've started a spread sheet with several columns for the products. The first column has the daily date. on a second sheet...
I suspect things are not all numbers. "JAN-00" could be the date value of 2000-01-01 formatted as Month-Year or could be just TEXT. you need to make sure those are all number / date values and not just text. Make sure the cell is formatted as 'GENERAL' or 'NUMBER' of 'DATE' and then enter the full date like 1/1/2026. It may and should then change to show the date in which ever is the default format but that us good and you can choose a different Date format to display as under the number formatting options on the home menu: