1-1 will always be converted by excel to a date, why can't you use text or
precede the entry with an apostrophe ' ?


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"showtunegirl" wrote in message
...
I need a column starting with 1-1 but it changes to a date. When I change
the format to text it isn't exactly what I need. Can you have a column
that
remains constant as in a rank and then have the corresponding data copied
to
that rank without having to retype all of the data for that entry?