date formula

  • Thread starter Thread starter pkcb113
  • Start date Start date
P

pkcb113

I am trying to input a date into a read only file. The column will not allow
me to expand the column and of course i get ######## in the column. I will
accempt 11/15/07, instead of 11/15/2007, but how to do this?
 
Try forcing the date as Text. You can do this by preceding your entry with
an apostrophe.

'11/15/07

The apostrophe will not show up in the cell.

HTH,
Elkar
 
pkcb113 said:
I am trying to input a date into a read only file. The column will not allow
me to expand the column and of course i get ######## in the column. I will
accempt 11/15/07, instead of 11/15/2007, but how to do this?
Click to expand...
It's probably just because the column isn't wide enough to show the full
date you require. Resize the column and it will show it properly.

Regards,
Ian
 
Back
Top