Cell Formats
 

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

Cell Formats
 

formatt the cells (or columns) you will be entering the data into as 'text'
before you start entering data.

"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

Cell Formats
 

Enter it with an apostrophe in front, i.e.

'01-63

and Excel will take this as a text value (the apostrophe will not show
in the cell).

Alternatively, pre-format the cell as Text beforehand, and then you
can enter it as 01-63.

Hope this helps.

Pete

On Jul 2, 6: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

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