How do I keep excel 2002 from changing fractions to dates?

P

pertimesco

eg. 1/1 would become Jan. 1. This comes up when I copy stats from a fantasy
baseball website into excel. How many stolen bases the player has, say he
was 1/2, would become a date.

Thanks in advance for your help, Ted.
 
F

Fredrik Wahlgren

pertimesco said:
eg. 1/1 would become Jan. 1. This comes up when I copy stats from a fantasy
baseball website into excel. How many stolen bases the player has, say he
was 1/2, would become a date.

Thanks in advance for your help, Ted.
Click to expand...

'1/1
Notice the apostrophe

/Fredrik
 
B

Bob Phillips

Ted,

Precede it by 0 and a space.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
P

pertimesco

Is there a way to have excel do this for me? Or would I have to go through
each cel one at a time to do this?
 
P

pertimesco

Could I make a macro that would do this? If so, could you explain how?

Thanks, Ted
 
F

Fredrik Wahlgren

Not if the data is already interpreted as a date

pertimesco said:
Could I make a macro that would do this? If so, could you explain how?

Thanks, Ted
Click to expand...
 
I

IanRoy

Hi, Ted;
Before pasting, format the cells where these kind of statistics will end up
as text. Or if you are using Data> Text to Columns, make sure, within the
wizard, to select "text" as the column format for the columns that contain
those statistics. For data that has aready been interpreted as dates, use the
single slash date format. On my machine this shows up at:
Format> Cells> Number> Date: 3/14
or
Format> Cells> Number> Custom: m/d;@
Hope this helps.
Ian.
 
Top