Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 007ab
  • Order by date
  1. 007ab

    Excel - Converting Julian Date to a Calendar Date

    I have the following data in Excel and would like to use the date function to return the exact year as shown. 18960526 18960527 18960528 18960529 18960601 When I use the date function and change the cell format to display dd/mm/yyyy Excel returns the year as 3096 (ading 1900 to 1896), how can...

Part and Inventory Search

Back
Top