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 ...
6th October 2009, 02:21 PM #1
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.
6th October 2009, 02:31 PM #2
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.
6th October 2009, 03:21 PM #3
I did export from SIMS, thanks for the heads up. I'll remember that if I can.
By park_bench in forum Office Software
Last Post: 10th June 2009, 03:25 PM
By sLiDeR in forum Thin Client and Virtual Machines
Last Post: 23rd February 2009, 03:37 PM
By randle in forum Windows
Last Post: 25th October 2007, 02:20 PM
Last Post: 4th June 2007, 10:10 PM
By chrbb in forum Windows
Last Post: 21st February 2006, 12:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)