Formatting Excel 2018

Occasional Visitor

Having issues with formatting. I tried to insert a single accounting line in cells, but in order to do it I had to first choose anything but single accounting, then go back and select single accounting. OK, that;s a minor annoyance. The big issue is when using the sum() function - a cell was formatted to show a negative value with the minus sign, and no matter what i did, the minus sign would not show up. Only way to get it to show up was to drag another cell that was formatting correctly over it. Thoughts?

Related Conversations
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Conditional Formatting values across tables
ChrisJP in Excel on
5 Replies
Adding Display Zero as Dashes to Custom Excel Number Format
emmagreen in Excel on
1 Replies
Relative conditional formatting
melissach in Excel on
8 Replies