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...
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].
Select the cell.
Press Ctrl+1.
If necessary, activate the Number tab.
Select the custom format string in the Type box, and copy it (Ctrl+C).
Do the same in your own workbook, but paste (Ctrl+V) instead of copy.
- i fix the problem.