Getting Dates When You Don't Want Them

E

Evie

(Select) the applicable cells, then click on FORMAT, then
CELLS. Under the NUMBER tab, you will find options
for "General, Number, Currency, Accounting..." Choose
the "Text" option. This should do the trick.

I hope this helps.

Evie

-----Original Message-----
I am cutting and pasting a large table from my browser
Click to expand...
into excell. One of the columns has information in the
format of"3/0" or "2/1" or "3/2". This data is being
translated to a date formatted cell with a number code
that then represents as a date.
 
Top