Mon 8 Dec 2008, 16:29Delegate Christie said...
Christie has attended:
Excel Intermediate course
Excel Advanced course
New data calculation
I have data coming in a 4,5 format (from a different region), instead of decimal (4.5). After changing the data to decimal, formulas do not update. How do I make the sheet calculate without having to do a 'Find/replace' operation?
Fri 19 Dec 2008, 08:48Trainer Simon said...
RE: new data calculation
Hi Christie,
Thank you for your question.
I have tried to recreate your problem and still having problems with getting you the answer.
Is it possible to send me part of the spreadsheet with that data and associated totals so I can look at the problem at source?
Regards
Simon
