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