Getting Dates When You Don't Want Them

  • Thread starter Thread starter Evie
  • Start date Start date
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.
 
Thanks but..Sorry it is not quite helpful. If I change the cell back to a "number" format. I get a 5 to 7 digit number. I need to get excell to stop converting the information at the time I paste it.

I really need this solved....
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

enable/disable auto-convert a NUMBER to DATE 4
date format will not change in Excel 3
Working with sports W-L records without Excel assuming I want dates... 0
Stop XL from changing format? 1
Remove date format? 3
Date Value Error 6
format text to date results in ############## 4
Excel Format Problem - Date Overrides Format 5

Back
Top