- 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?
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.
Looking forward to your answer.