LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bill gras
 
Posts: n/a
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 ?
Can you please help ?

hopeful Bill

bill gras
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate numbers between 2 dates Rajiv@Ivey Excel Discussion (Misc queries) 0 May 17th 05 06:25 PM
how do i remove hyphens from between numbers ian78 Excel Worksheet Functions 5 April 13th 05 02:41 PM
How do i remove the hyphens between numbers without having to edi ian78 Excel Discussion (Misc queries) 2 April 12th 05 04:39 PM
dates change to numbers Debbie Excel Worksheet Functions 1 March 29th 05 10:31 PM
micosoft excel dates entered but changed to sequencial numbers ho. ten twenty Excel Worksheet Functions 1 December 10th 04 02:29 AM


All times are GMT +1. The time now is 06:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"