Formatting Numbers – I am sure, that you don’t know Everything … | René Martin

Name: Formatting Numbers – I am sure, that you don’t know Everything … | René Martin
Start: 2021-03-09T18:00:00Z
End: 2021-03-09T20:00:00Z

Hosted By

Alan M. and Tea K.

Formatting Numbers – I am sure, that you don’t know Everything … | René Martin

Details

Come along to this London Excel Meetup with René Martin as he presents on Formatting Numbers in Excel.

Be Warned! You will learn lots.

You know how to change the format of numbers to currency, date and percentage. But: do you know:

the limits of the numbers? What is a number in Excel? 20:30? 200:30? 2000:30? 20000:30?
what are the differences between currency and accounting? I found nine differences.
how to format 1,400,000 to "1.4 MM GBP"?
that Excel does not only know the conditional formatting [black], [red], [blue], … but 56 more. And? Who needs that?
where to use ;;;?
how to create a calendar in different languages?
the bug “mm”?
how to generate lists with “@”?
Some database-systems push text “under” the numbers. How to get rid of it? I found seven ways.

René organises the Excel Stammtisch events in Munich. These events are organised around Germany and have been going for many years.

These events are part of my inspiration for creating the London Excel Meetup in 2020. I found out about these through Andreas Thehos, who some of you will know from the group.

I met René in Bulgaria in 2019 at an Excel conference. He is extremely knowledgeable (unlike me), but like me, he wrote a book last year;