date formula

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?
 
E

Elkar

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
 
I

Ian

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
 
Top