B
budsimrin
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When I opened a spreadsheet created in Excel 2004 with List Manager, a date cell lost its date formatting. Every time I enter a new row of data in the list, when I enter info like 3/27 into the date cell, I get an "out of range" error. I fix this by formatting the cell and then re-entering 3/27.
However, I can't find any method to permanently change the date cell's format. I have to change it every time I add a new row of data.
How does one change the formatting of cells in new rows that are added to List Manager?
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
When I opened a spreadsheet created in Excel 2004 with List Manager, a date cell lost its date formatting. Every time I enter a new row of data in the list, when I enter info like 3/27 into the date cell, I get an "out of range" error. I fix this by formatting the cell and then re-entering 3/27.
However, I can't find any method to permanently change the date cell's format. I have to change it every time I add a new row of data.
How does one change the formatting of cells in new rows that are added to List Manager?