Ask Your Question
0

How can I make negative number display in red on my spreadsheets

asked 2016-05-28 00:20:52 +0100

moonvine gravatar image

I am using a fully updated version of MS Windows 10 on a Samsung PC. I have downloaded and installed the latest version of Libre Office (5.1.3). The options and help instruction for negative currency management seem straight forward and simple but I cannot get them to work. Help please. Today is May 27, 2016

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-05-28 01:33:11 +0100

timelord gravatar image

image description

Calc

Format/Cells.../Numbers

Tick Negative numbers red

edit flag offensive delete link more

Comments

Thanks for your input. I am and have been using the instruction you provided. The only difference is I am working with currency. Otherwise its the same. However, there is a difference in my input data. It is a spreadsheet I created from a CSV file I downloaded from Citibank. I deleted one of the negative number from the spreadsheet and re-entered it from the keyboard and it immediately changed color to red. I will try working with the source data. Thanks again.

moonvine gravatar imagemoonvine ( 2016-05-29 23:45:13 +0100 )edit
Login/Signup to Answer

Question Tools

Stats

Asked: 2016-05-28 00:20:52 +0100

Seen: 575 times

Last updated: May 28 '16