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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

New data calculation

ResolvedVersion 2007

Mon 8 Dec 2008, 16:29 Delegate 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:48 Trainer 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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

New data calculation

New data calculation

RE: new data calculation

Excel articles

Excel tip:

Freeze Rows and Columns to keep lables displayed