Hi all,
Anyone got a clue why i have an excel spreedsheat that when you enter a function it doesn't work out the value?
Tryed dropping in some basic functions like =1+1 but it just stays as text, used the F9 function to update the values but no luck, made sure the cell was set to general or number still no luck, tryed copying and pasting the data to a new spreadsheet and still no luck. The only way i can get the functions to work is to do a copy values to a new spreadsheet, so whats happening or my excel duff?
Anyone got a clue why i have an excel spreedsheat that when you enter a function it doesn't work out the value?
Tryed dropping in some basic functions like =1+1 but it just stays as text, used the F9 function to update the values but no luck, made sure the cell was set to general or number still no luck, tryed copying and pasting the data to a new spreadsheet and still no luck. The only way i can get the functions to work is to do a copy values to a new spreadsheet, so whats happening or my excel duff?