Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » New data calculation
Resolved · Medium Priority · Version 2007
Christie has attended:
Excel Intermediate course
Excel Advanced course
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?
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
|
Excel tip:Shortcut for accessing recently opened filesTo get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu. |
We'll call during UK business hours
Server loaded in 0.09 secs.