Last answered:

02 May 2020

Posted on:

30 Apr 2020

0

custom formatting

  1. 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?
  2.  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?
1 answers ( 0 marked as helpful)
Instructor
Posted on:

02 May 2020

0
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

Submit an answer