Cell Formats
Two choices:
Either precede your entry with an apostrophe '. The apostrophe will
not show in the cell, only the formula bar.
Or give the cell the number format of Text
HTH
Kostis Vezerides
On Jul 2, 8:21 pm, ej wrote:
I have been trying to enter 01-63 as an exaple and it always changes it into
a date like jan-63. I have tried everything i can think of to fix it. Any
suggestions please let me know
|