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

microsoft excel training day courses near kent - use excell sheets

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Use of excell sheets

microsoft excel training day courses near kent - Use of excell sheets

ResolvedVersion Standard

kim has attended:
Excel Intermediate course

Use of excell sheets

I use some protected excel sheets with dates that automatically make the dates american format. How do I attempt to change those to UK ones.

RE: use of excell sheets

Dear Kim

Thanks for attending Excel Intermediate.

The date formatting is normally dependant on the regional settings of your computer

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

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.09 secs.