All Questions
8
questions
0
votes
1
answer
133
views
Excel 2016 Stopping automatic formatting of timestamps
I'm entering a list of timestamps from a video into Excel 2016. However, when I reach numbers above 24, Excel reacts like it's a 24 hour clock and changes my number. For example, if my timestamp is at ...
0
votes
1
answer
53
views
Microsoft Excel formula not working properly
I want to format a cell which is greater than 365 value. The problem is I put the formula of datedif(a1,b1,"d")&" "&"Days" and the result in the cell is 390. I ...
0
votes
1
answer
448
views
Excel 2016 Chart > Date and Text on the same Axis
I received an interesting question yesterday during at work. Is it possible to have Date and Text values on the same Axis in Excel Chart, but that this "text" is actually formatted or somehow ...
0
votes
1
answer
55
views
Can I use conditional formatting in an Excel PivotTable to format cells based on specific fields?
I have the results of numerous tests run on several sub-samples. Many sub-samples make up a sample. Between 5 and 10 samples make up a lot, and I have five lots I'm trying to analyze.
Each one of ...
0
votes
1
answer
1k
views
How does Increase decimal and Decrease decimal work in Excel
How the increase decimal operation is performed in Excel and how they done it?
Case 1 :
I enter a number in a cell whose number of digit is less than 11.
For instance A1 cell value be : 123
If I ...
0
votes
2
answers
88
views
Excel 2016 time formatting cells
Using Excel 2016, I want to enter 90 minutes as 90:00, or 75 minutes and 33 seconds as 75:33, or 102 minutes and 54 secs as 102:54; then sum the column to report as 268:27. How do I format the data ...
1
vote
0
answers
97
views
Conditional formatting in Excel: Referencing entire table column [duplicate]
In Excel I am trying to apply conditional formatting to an entire table column (it should be automatically applied, when new rows are added into the table)
However, the conditional formatting rules ...
0
votes
0
answers
54
views
In MS Excel Is there any way to use number formatting on entries with a mix of letters and numbers?
I'm trying to decimal justify a list using the number formatting, but the numbers in question happen to have letters in them, and they're being ignored. Is there any way to get Excel to recognize ...