The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data formating

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Data formating

Resolved · Medium Priority · Version 2007

ReplyMon 22 Feb 2010, 17:00 Edited on Tue 9 Mar 2010, 15:48Delegate Lorna said...

Data formating

my dates show as 23-sep-1980, i cannot seem to change this format to numbers only.

For upcoming training course dates see: Pricing & availability

ReplyTue 23 Feb 2010, 10:52Trainer Stephen said...

RE: data formating

Hi Lorna

Thanks for your question

We first need to check if the dates are in fact being entered in a recognisible date format. Can you check to see if they are right or left aligned in the cell, and then please advise me.

If left aligned then they are being formated as text, and this would explain the problem

Thanks

Stephen

ReplyTue 23 Feb 2010, 15:43Delegate Lorna said...

RE: data formating

Hi Stephen,

thanks for getting back to me, yes the dates are left aligned always.

I have to import the data from our MIS (SIMS.NET), and i dont think i can change anything!!!

thanks

Lorna

ReplyWed 24 Feb 2010, 10:27Trainer Jacob said...

RE: data formating

Hi Lorna

Further to your series of posts, Stephen has notified me of your current requirements. Having discussed this we agree that a solution is available but is beyond the scope of this forum.

I shall email you directly with our proposed action.

kind regards

Jacob

Tue 2 Mar 2010: Automatically marked as resolved.

Excel articles

· How To Link Between Spreadsheets In Excel
· Tracking In Excel 2003
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Easing the Transition to Excel 2007
· What Do The Formula Error Messages Mean In Excel?

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

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips

Calculating Cost variances