+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Excel formulas and formatting not working in Technical; Strange one this! I am knocking up a spreadsheet of my year 7 students to import in to a web ...
  1. #1
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30

    Excel formulas and formatting not working

    Strange one this!

    I am knocking up a spreadsheet of my year 7 students to import in to a web based exam site. I have set up a formula to generate a random number as the users passwords. I have also changed the formatting of the date e.g. changed from 31 July 1997 to 31/07/1997

    Anyway neither settings work. The formula just sits in the cell without actually showing the result and the formatted cell still shows the old format.

    I have found a part fix on google where it suggested pressing F2 then F9 and return. This does update the cell but I have 400 cells to do and I'm worried that it might happen to the staff or students as well so I'm preparing for the storm.

    Any ideas?

  2. #2
    DrPerceptron's Avatar
    Join Date
    Dec 2008
    Location
    In a house
    Posts
    926
    Thank Post
    34
    Thanked 134 Times in 114 Posts
    Rep Power
    41
    In Office 2007 there's a calculate button onb the Formula tab which has the Calculation options etc - perhaps you need to change it to automatically?

    If it's fomatted sims data into O2k7 (or 2010) I've never been able to use excel formulaes etc to do anything with the data, I always had to export as unformatted text/csv data.

  3. #3
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,550
    Thank Post
    518
    Thanked 56 Times in 50 Posts
    Rep Power
    30
    I did export from SIMS, thanks for the heads up. I'll remember that if I can.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Excel - Conditional Formatting using formula
    By park_bench in forum Office Software
    Replies: 1
    Last Post: 10th June 2009, 02:25 PM
  2. Formatting VM partition
    By sLiDeR in forum Thin Client and Virtual Machines
    Replies: 1
    Last Post: 23rd February 2009, 02:37 PM
  3. Help with conditional formatting
    By randle in forum Windows
    Replies: 3
    Last Post: 25th October 2007, 01:20 PM
  4. Replies: 5
    Last Post: 4th June 2007, 09:10 PM
  5. formatting w98
    By chrbb in forum Windows
    Replies: 6
    Last Post: 21st February 2006, 11:36 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •