Ask Your Question
0

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

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

moonvine gravatar image

updated 2020-09-05 17:54:37 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 13:26:04.709615

1 Answer

Sort by » oldest newest most voted
1

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

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 +0200 )edit

Question Tools

Stats

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

Seen: 1,658 times

Last updated: May 28 '16