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

excel advanced

ResolvedVersion 2003

Excel Advanced

Hi ,

the Auditing Toolbar is useful for what?
In which way it works?

Thanks a lot

Stefania

RE: Excel Advanced

Hi Stefania

I believe this question has been posted more than once, and has been answered.

Kind regards
Amanda

Fri 6 Feb 2009: Automatically marked as resolved.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.