View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bill gras bill gras is offline
external usenet poster
 
Posts: 48
Default numbers contain hyphens to dates

I have copied and pasted a file from a website into Excel 2000,in column "B"
there was a entry like this:-
11/14 which means 11th place from 14 positions. Excel shows this entry as
Nov-14 (a date). I have tried
every thing that I could find , but can not bring it back to 11/14 (which is
very important for my end result)
There are about 300 rows that I have to import every day.
Is there a worksheet function that you know of ?
Or is there a macro that would work?
Can you please help ?

hopeful Bill

--
bill gras