Formatting

Resolved · Low Priority · Version Standard

Formatting

Ruth has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Ruth [2 posts] (2008 Feb 27 Wed, 15:11) Reply

some workbooks I receive have extra space bars in some cells and are therefore treated as text. How can I change them so that they are treated as numbers.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
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	3	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	0	FULL
2003	2008 Dec 17 Wed	Bayswater	0	FULL
Full Schedule: See all 94 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: formatting

by - trainer Mark gold contributer [287 posts] (2008 Mar 6 Thu, 14:25) Reply

Hi Ruth

Thankyou for attending the course, i hope you really enjoyed it.

The answer to your question is simply to fix, what you will need to do is highlight the cell are you want to change, then go to the format menu and choose cells. From the number tab choose number or general then click OK

This should do the trick

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Best Regards

Mark East

· Customized Financial Excel Courses in London
· What's Better Than the Help Function in Excel? Microsoft Training
· A Beginners Guide To Formulas In Excel
· Reporting and Analysis with Excel
· Tips for Transitioning to Excel 2007

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips

Rate this page: