Excell cell formatting

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

Resolved · Low Priority · Version Standard

Marthie has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Marthie [3 posts] (2008 Feb 14 Thu, 16:19) Reply

How do I get rid of the !box next to numbers enterred as text?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
2003/XP	2008 Jul 25 Fri	Bloomsbury	3	book now	£224	£235
2003/XP	2008 Jul 29 Tue	Bayswater	0	FULL
2007	2008 Jul 30 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 6 Wed	Bloomsbury	4	book now	£224	£235
2003/XP	2008 Aug 11 Mon	Bayswater	5	book now	£195	£205
Full Schedule: See all 138 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excell cell formatting

by - trainer Pete platinum contributer [719 posts] (2008 Feb 15 Fri, 09:32) Reply

Hi Marthie, Thank you for the post, in answer, to stop the info box from appearing, go to the menu command, View. Error Checking, and deselect the box Number Stored as Text. I hopw that helps, Best Regards Pete

· Benefits of learning about Excel charts
· Tips to Facilitate Printing of Excel worksheets
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Office and the Small Business: Part 1 Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.