View RSS Feed


MS Office related posts.

  1. Using Dates in SIMS Reporting

    , 4th January 2012 at 07:12 PM (100 Grades Per Minute)
    When you output dates in SIMS with the Reporting tool, the results will come out as text and cannot be converted into a proper date with the number format window. This is a fix used in the SIMS Standard Portrait template to prevent Excel from throwing a fit and entering the data incorrectly. You can modify the template and remove the fix but that is best left to advanced users, there is a simpler option.

    Let's take a date in the format "1 March 2012" in cell C2. You can ...
    Work , SIMS , Technical , Office