| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use hyphens instead of slashes when representing dates? | Excel Discussion (Misc queries) | |||
| prevent converting numbers with hyphens to dates | Excel Discussion (Misc queries) | |||
| numbers contain hyphens to dates | Excel Worksheet Functions | |||
| how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
| How do i remove the hyphens between numbers without having to edi | Excel Discussion (Misc queries) | |||
Threaded Mode
