How do I keep excel 2002 from changing fractions to dates?
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. |
"pertimesco" wrote in message ... 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. '1/1 Notice the apostrophe /Fredrik |
Ted,
Precede it by 0 and a space. -- HTH RP (remove nothere from the email address if mailing direct) "pertimesco" wrote in message ... 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. |
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? "Bob Phillips" wrote: Ted, Precede it by 0 and a space. -- HTH RP (remove nothere from the email address if mailing direct) "pertimesco" wrote in message ... 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. |
Could I make a macro that would do this? If so, could you explain how?
Thanks, Ted "Fredrik Wahlgren" wrote: "pertimesco" wrote in message ... 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. '1/1 Notice the apostrophe /Fredrik |
Not if the data is already interpreted as a date
"pertimesco" wrote in message ... Could I make a macro that would do this? If so, could you explain how? Thanks, Ted "Fredrik Wahlgren" wrote: "pertimesco" wrote in message ... 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. '1/1 Notice the apostrophe /Fredrik |
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. "pertimesco" wrote: 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. |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com