training+excel+microsoft

training+excel+microsoft - Excel

Resolved · Low Priority · Version Standard

Excel

Ann-Marie has attended:
Excel Advanced course

by - delegate Ann-Marie [1 post] (2007 Oct 10 Wed, 16:23) Reply

what is the shortcut to get rid of decimals?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	1	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	5	book now	£219	£235
Full Schedule: See all 96 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 10:44) Reply

Hi Ann-Marie, Thank you for your post, other than a convoluted key board operation involving Ctrl keys and Tab keys to reach the Format, Cells, Number, decimal places input box, I think the easiest way to reduce or get rid of decimals is to click the Decrease Decimals button on the Formatting Toolbar.

· Basic Excel Training
· Excel in the Home Office
· What's Better Than the Help Function in Excel? Microsoft Training
· Identifying Suitable Candidates For VBA For Excel Training
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Rate this page: