G Guest Feb 9, 2006 #1 i am entering a date value into a cell and i that it shows is "##" Even when i print it shown "##" and no date why?
i am entering a date value into a cell and i that it shows is "##" Even when i print it shown "##" and no date why?
G George Feb 9, 2006 #3 Steve said: i am entering a date value into a cell and i that it shows is "##" Even when i print it shown "##" and no date why? Click to expand... Normally the # character shows up when the column is not wide enough to display a date or number. Try widening the column to see if you can see the date, you might need to choose a different date format that takes up less space. George
Steve said: i am entering a date value into a cell and i that it shows is "##" Even when i print it shown "##" and no date why? Click to expand... Normally the # character shows up when the column is not wide enough to display a date or number. Try widening the column to see if you can see the date, you might need to choose a different date format that takes up less space. George