decimal place

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Decimal place

Decimal place

resolvedResolved · Low Priority · Version 2003

Desmond has attended:
Excel Intermediate course
Excel Advanced course

Decimal place

When I copy figures from a spreadsheet showing 2 decimal places why does it show 4 decimal places on the sheet I pasted on?

RE: Decimal place

The sheets might have different defaults. You can change a range of cells by clicking Format/Cells and the choosing the decimal places you want.


 

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

View all Excel hints and tips


Server loaded in 0.08 secs.