new data calculation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » New data calculation

New data calculation

resolvedResolved · Medium Priority · Version 2007

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?

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


 

Excel tip:

Shortcut for accessing recently opened files

To get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu.

Recently opened files are listed down the bottom of the File menu - type in the number next to the file you wish to open and it should appear on your screen.

View all Excel hints and tips


Server loaded in 0.09 secs.