excel beginners

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel beginners

resolvedResolved · Low Priority · Version Standard

Andrew has attended:
Excel Introduction course

Excel beginners

How do you arrange dates in order in a table.

RE: Excel beginners

Hi Andrew, Thank you for your post, to answer your question, in the list or database that the dates appear, click in the column with the dates and on the toolbar choose the button A-Z to arrange them in sequential order. Look forward to hearing from you again. Hope that helps, best regards Pete


 

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.11 secs.