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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by earnestwong

  1. earnestwong

    Convert Date to Month / Year

    Perfect, your worth a star! many thanks.
  2. earnestwong

    Convert Date to Month / Year

    Hi i have a date field in one column, in another i have the following... =TEXT(A1,"mmm yy") This works fine as long as there is data in the field if the field is blank then it just returns Jan 00. How can i get it to not display Jan 00 if the date field is blank? thankyou, Erny
  3. earnestwong

    Reporting on cell information

    Hi, i have an excel table with the following columns... GBP, Euro, Date Raised Exmple data for above columns... GBP, Euro, Invoice Date Raised £120, n/a, 14/01/2008 £90, n/a, 11/02/2008 n/a, €2345, 17/03/2008 £120, n/a, 14/01/2008 £120, n/a, n/a I want a new worksheet at the bottom which...
See more

Part and Inventory Search

Back
Top