All Questions
6
questions
0
votes
4
answers
39k
views
Why does Excel add leading apostrophes to some of my text cells?
I have a worksheet containing, among other things, a table object. All data in the worksheet was added by me manually, including the data and column headers in the table.
I just noticed that in 13 of ...
- 3
0
votes
1
answer
45
views
Delete only lateral edge in MS-excel?
Is it possible to delete only the lateral edges in a excel matrix?
In the attacched image you can see tha matrix and you can notice that is almost impossible to delete left/right formatted edges ...
- 756
0
votes
1
answer
139
views
I've deleted some cells and cleared everything out and it keeps reverting back to DATE format
I've never changed formatting to date: I always keep it in General unless I need to make it different.
Since my last Update, everything now changes to date when I either copy, paste, or when I ...
- 1
0
votes
1
answer
55
views
Display time difference - Formatting
I have a table of times and a formula that works out the difference between the times but having some difficulties formatting the output.
For example I would like:
# Time Gap
1 23:55....
- 103
2
votes
2
answers
26k
views
Excel: if duplicate cell value found in another column then highlight green
Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...
- 23
0
votes
2
answers
81
views
Formating my Excel Cell Formulas
What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.
- 1