how can i do custom formatting of a cell by ensuring that the currency symbol is showing and the number of decimal places is still intact? when i have positive numbers, negative numbers and zero figures in my cells? also if i have different rows&columns containing different values how can i select it and apply custom formatting to it e.g d1-d10 contain different values, on the same sheet h1-h10 also contain separate different values etc how can i select these figures without affecting the text between these columns (i.e column e, f, g,...) and applying custom formatting to it?

Hi Eze! Thanks for reaching out. Can you please share with us a link to the lecture(s) your questions are referring to?If you can further support your question with screenshots that will better indicate/visualise your queries, we would be able to assist you better. Thank you. Looking forward to your answer.Best,Martin

Follow this topic

Eze Abolaji Abosede

Last answered:

02 May 2020

Posted on:

30 Apr 2020

custom formatting

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

02 May 2020

custom formatting

Submit an answer