![]() |
Empty cells showing that they are default formated to "Date"
I created a spead sheet with one column set as a date the first to the end of
the month. The other columns have various in text and accounting info. If I click on a empty cell it show in the format section on the bar the the cell is set up to have a date entry. This is all over the page. Can any one tell me why this is happening? -- Fred |
Empty cells showing that they are default formated to "Date"
You can correct that by setting the formating for the other columns. Simply
click on the column(s) then right click and select Format cells, or select the column(s) then go to Format and then Cells. In the selection list choose any option beside date. "FredC" wrote: I created a spead sheet with one column set as a date the first to the end of the month. The other columns have various in text and accounting info. If I click on a empty cell it show in the format section on the bar the the cell is set up to have a date entry. This is all over the page. Can any one tell me why this is happening? -- Fred |
All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com