Preceede your data entry with an apostrophe [ '10-12 ], which will *not* be
displayed in the cell, but will be visible in the formula bar.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
10-12 is a size not a date, although I have formatted the cell as text, it
keeps reverting to custom
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.