All Questions
8
questions
0
votes
2
answers
753
views
What is going wrong with importing and formatting the following .csv data set into Excel?
I'm trying to import the following CSV data set into Excel. I'm using the Text Import Wizard to set the right delimiters. So far, I used the ";" and "," delimiters.
Here is the ...
0
votes
2
answers
461
views
Excel automatically changes format from numeric to either date or other number format
I wrote a query in postgresql to get the data I need and want to further analyze it in excel. But everytime I past my numeric variables it either turns into a short date format or a number like 27....
1
vote
3
answers
2k
views
How to reorganize vertically repeating data to horizontal?
I have data on 1 variable from 1970 to 2017 from all the countries in the world. this data is organized as one large vertical list, with first a column with the (repeating) country name, then a column ...
0
votes
1
answer
2k
views
Excel Chart data table. Formatting one row (TOTAL) only
Im trying to build a chart and Highlight TOTAL row in data table (that one underlined on screen) ;).
I can format only whole chart data table or nothing.
By a trick I did a "hidden" (no colour and ...
0
votes
3
answers
13k
views
Excel Conditional Decimal Formatting
I am trying to have decimal places display based on the value inside a given cell. I more or less understand how to custom rules work, and have come up with this rule: [>=10]#,##0.0;[<10]0.00
It ...
0
votes
2
answers
313
views
How to change a Generally formatted "20170824 08:45:58:544" into a Time formatted hh:mm:ss.ss?
The title is the gist of my problem. I've got a couple of thousand of these I need to convert into a hh:mm:ss.ss format while retaining (though not showing) the yyyymmdd converted to a mm/dd/yyyy ...
1
vote
0
answers
746
views
Format datatable using VBA (values are as Double but String is needed for formatting)
Currently working on a vba script that makes charts automatically. I would like to add a datatable which is done using:
.HasDataTable = True
However I would like to show the values of series as ...
-1
votes
1
answer
183
views
How to count two different column?
I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project.
Project Status Project Pending Closed
VIVA closed ...