All Questions
4
questions with no upvoted or accepted answers
0
votes
1
answer
453
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 ...
- 121
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 ...
- 151
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 ...
0
votes
2
answers
89
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 ...
