Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering a date into cell and get ## symbols
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering a date into cell and get ## symbols
Make the cell wider
-- Regards, Peo Sjoblom Portland, Oregon "Steve" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
entering a date into cell and get ## symbols
Steve wrote:
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? 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|