Ask Your Question

moonvine's profile - activity

2016-10-11 13:58:55 +0200 received badge  Taxonomist
2016-05-30 17:20:57 +0200 received badge  Famous Question (source)
2016-05-29 23:45:13 +0200 commented answer How can I make negative number display in red on my spreadsheets

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.

2016-05-28 18:15:30 +0200 received badge  Notable Question (source)
2016-05-28 11:04:44 +0200 received badge  Popular Question (source)
2016-05-28 00:20:52 +0200 asked a question How can I make negative number display in red on my spreadsheets

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

2016-05-25 05:31:53 +0200 received badge  Enthusiast
2016-05-24 22:40:58 +0200 commented question Unable to make negative numbers in Calc display red

I'm using the latest version of LibreOffice and MS Windows 10 fully updated. Using the latest procedure in LibreOffice Calc I cannot negative numbers (currency) display in red. Today is May 24 2016. Help please.

2015-01-17 11:57:29 +0200 received badge  Notable Question (source)
2015-01-17 11:57:29 +0200 received badge  Famous Question (source)
2014-12-15 03:22:20 +0200 received badge  Famous Question (source)
2014-12-15 02:57:09 +0200 answered a question managing date formats in calc (changed the question to add "date")

While trying to duplicate the situation that prompted my original question I discovered several conflicting scenarios between MS XCEL 97-2003 (used by my bank in 1Q 2014), Libre Office 4.x and Open Office 4.1.x. The bank was using tab delimiters in the download XCEL file and when I opened the download file the YYYY in the date changed from 2014 to 2010. Yes, I know this is different than earlier description of my issue. About midway through the year the bank switched to Open Office 1.1 for the CSV download file. In addition I upgraded my copy of Libre Office in this time frame. Using Libre Office 4.3 and 4.4 (beta) I now have the dates in the summary I have created in MM/DD/YYYY order. I'm using that format because it is what the bank started the year with.

As a final note, pay close attention to the download CSV file and the software you use. My thanks to everyone who offered suggestions and the benefit of their experience.

2014-12-11 02:02:26 +0200 commented answer managing date formats in calc (changed the question to add "date")

I'll see what I can do

2014-12-10 23:18:18 +0200 received badge  Student (source)
2014-12-10 22:54:59 +0200 commented answer managing date formats in calc (changed the question to add "date")

Lupp, its me again. The dates in my previous comment were in a column when I entered them. I don't know how to get them in a column this purpose.

2014-12-10 22:47:36 +0200 commented answer managing date formats in calc (changed the question to add "date")

Lupp, thanks for your suggestions. I will try them later today or tomorrow. Also note that I changed the title for my question. It is more definitive now. I am including the date portion of the December file I downloaded. I have noted that each date is preceded by ' so I suppose this formats the original file dates as text.

2014-11-26 2014-11-13 2014-12-03 2014-12-03 2014-11-07 2014-11-07 2014-11-07 2014-11-07 2014-11-08 2014-11-10 2014-11-10

2014-12-10 21:53:50 +0200 received badge  Editor (source)
2014-12-10 21:50:47 +0200 received badge  Notable Question (source)
2014-12-10 10:44:50 +0200 received badge  Popular Question (source)
2014-12-09 23:50:00 +0200 asked a question managing date formats in calc (changed the question to add "date")

Each month the bank holding my credit card account provides a downloadable statement in CSV format. Each month I download the CSV file and covert it to a spreadsheet format using CALC. It quarter I consolidate the monthly files using "copy and paste" The worked well until July 2014. The dates in the bank file were in MM/DD/YYYY format and they later switched to YYYY/MM/DD format. Using CALC in Libre Office 4.4 (beta) to move from CSV to spreadsheet format I managed to convert the dates to MM/DD/YYYY and the year displayed as 2014. Eg., 11/15/2014. However, when performed the quarter consolidation the dates suddenly displayed as 2018. Eg., 11/15/22018. I have been unable to resolve this issue. All default beginning dates are set to 12/30/1899.

There may be something obvious I should change but I can't find it. Help will be appreciated. I'm using a fresh copy of Win 8.1 home if that has some bearing on the problem. My computer is a new Samsung all in one.

2013-11-03 19:07:11 +0200 commented answer How do I total a currency column in Calc

Mariosv, thanks for your help. Using your suggestion I was able to work through my problem

2013-11-03 19:06:33 +0200 commented answer How do I total a currency column in Calc

Edward, thanks for your help. Using your suggestion I was able to work through my problem.

2013-11-03 12:39:45 +0200 received badge  Popular Question (source)
2013-11-03 00:11:52 +0200 asked a question How do I total a currency column in Calc

My bank provides the ability to download my monthly credit card statements in CSV format. I load these into Calc and categorize my expenses for taxes and budget comparison. I'm using Calc 4.1.x and win 8.1. I'm using a function such as =sum(a1:a20). The usual total result is the value in a1 or some random number or zero.

In addition I cannot get negative numbers to display in red. The are preceded by a minus sign.

Suggestions or other help will be appreciated.