vba excel - Excel intermediate

The UK's most regular instructor-led training courses.
Training information: vba excel · Excel course london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel intermediate

mike has attended:
Excel Intermediate course

by - delegate mike [1 post] (2007 Feb 23 Fri, 09:31) Reply

how many decimal places can i format a cell with?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: excel intermediate

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 23 Fri, 09:36) Reply

Hi Mike,

Under general conditions you can have up to 30 decimal places!

Thanks

Tracy

· Training Budgets In A Bad Economy
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Excel and Inventory Management
· Reasons Why VBA for Excel Training Fails
· Crazy Things People Have Done With Excel

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips