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

Excel

ResolvedVersion 2007

Sat 2 Oct 2010, 12:06 Delegate Gary said...

Gary has attended:
Excel Intermediate course
Excel Advanced course

Excel

I have a csv file exported into excel and it has produced a number value as a date (180110) and trying to get this to show as 18/01/10 but cant as it changes it to 13/02/2393. How do i get this to show?

Also there is a 0 missing off dates such as 01/01/08 which shows as 10108, how do i get this into the same format as above?

Cheers

Gary

Tue 5 Oct 2010, 13:18 Trainer Simon said...

RE: Excel

Hi Gary,

Thank you for your question.

What progam are you uisng to export to CSV?

What format are the dates shown in that program before exporting to CSV?

Regards

Simon

Thu 21 Oct 2010, 15:39 Trainer Simon said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 28 Oct 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Excel

Excel

RE: Excel

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Quickly insert a function