Forum Discussion
designing your own number formats, don't work
in four blank cells, i entered 1200 in the cell A1, i entered -8000 in the second cell A2, i entered 0 in the third cell A3 and i entered the text Hello There! in the cell A4. Then i selected all fo...
What do you see when you open the attached workbook?
- i see 1,200 blue, i see (8000) in red, i see the 0 in green and i see the text Hello in cyan. But why did you ask this question? i don't understand, what you want to say me.
Just copy/paste format string which HansVogelaar suggested from his file. Typing manually perhaps you shall use semicolons instead of commas, depends on your regional settings.
- Which setting should i change? I am reading the excel 2019 all-in-one foer dummies i copy the formula, i wrote above, as it's written in the book, namely, [Blue]#,##0_);[Red](#,##0);[Green];[Cyan].
