Entering numbers

The UK's most regular instructor-led training courses.
Training information: excel 2003 visual basic intermediate course · Excel advanced · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Entering numbers

Susan has attended:
Powerpoint Introduction course
Excel Introduction course

by - delegate Susan [2 posts] (2008 May 12 Mon, 16:31) Reply

why do I sometime have to enter an ' before entering a number, if I don't the format is automatically changed

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: entering numbers

by - trainer Tracy platinum contributer [586 posts] (2008 May 13 Tue, 06:00) Reply

Good question! When typing in numbers Excel assumes you want to be able to add them up, so it defauls to formatting them to number style. By putting a ' in you are overriding that setting and able to type the number in as text.
Hope that helps
Tracy

· Microsoft Excel Training: Essential for Today's Employees
· Advanced level training: Microsoft Excel and the Web
· Microsoft Office and the Small Business: Part 1 Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Please browse our web site to find out more about
excel 2003 visual basic intermediate course and other Microsoft training courses.