All Questions
6
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 ...
- 101
2
votes
1
answer
6k
views
Ms Excel: Is there any way to superscript a character in custom format?
I want to display the measuring unit (cubic meters) in the cell using custom format ( #.##0,00" m3"), but I want to superscript the character "3". Is there any way to do that?
Ale B
0
votes
1
answer
39
views
Turn four rows into running page header in Excel
I have an Excel sheet that I'm trying to format for print. I want to turn the top four rows of the sheet (or quite frankly any four rows, I don't care where they're stored) into the header so that ...
- 221
1
vote
1
answer
2k
views
Why is copy paste losing all formatting by default?
Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works.
So far i ...
- 380
0
votes
1
answer
5k
views
Large Number, Abbreviated Formatting
Consider the following scenario. I have a data column that contains a large list of numeric, whole number values. Some of these values are comparatively small (i.e. 1,000) while others are very ...
- 4,515
3
votes
2
answers
5k
views
Open blank Excel spreadsheet with all cells in text format by default
When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes.
Is there a way for me to open up a new instance of Excel (not from a template, I ...
- 616