All Questions
Tagged with microsoft-excel formatting
241
questions
0
votes
1
answer
76
views
How do I use custom formatting to change number from ########### to #####.##.##.## in Excel?
I have a very large list of numbers that range in size from 9-17 characters. I need to add periods to make them compatible with a specific program.
Example:
1000409180201 --> 10004.09.18.02.01
Is ...
- 3
0
votes
1
answer
236
views
Is there a way to copy & paste a format style in Word?
I export some data (daily) from Access to Word and each time, I need to take certain formatting steps (about 6 steps) for the final Word Document.
Instead of going through each step, one by one, each ...
- 131
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
0
answers
330
views
In MS Excel cell format, How to change the default time duration from "number of days" to "number of minutes"?
In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to ...
- 331
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
0
votes
1
answer
20k
views
How to change default text color in MS Excel
How can I make many edits to a MS Excel 2010 spreadsheet and save the edits I make using a different color (i.e. RED). Right now, I have to change the color of each and every cell in the spreadsheet, ...
- 153
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 ...
Robert de Clair
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 ...
-1
votes
2
answers
795
views
How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?
I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...
- 183
-1
votes
2
answers
246
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...
-1
votes
1
answer
49
views
How to format a CSV with blank data in some places
I have a CSV with the following headings (and example data):
Serial Number, Photocopier Model, Copy Volume, MeterType
432322,Canon,Copy Volume, MeterType
,,23423,BW
,,983,Colour
,,4405,A3 BW
,,34,A3 ...
- 116
-1
votes
1
answer
7k
views
Alphanumeric cell format (using custom format)
I want to display an alphanumeric code in this format:
A/DDDDD/DDDD
Where A is letter and D is digit. If there are less digits, a leading 0 should be displayed.
Example:
W/1/1 displays: W/00001/...
- 107
-1
votes
2
answers
725
views
Excel conditional formating: use fill color based on a different cell's existing fill color
The following table represents the value I’m working with in Microsoft Excel.
+---+----+-----+---------+-----+
| | A | B | C | D |
+---+----+-----+---------+-----+
| 1 | | Min | ...
- 123
-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 ...
- 1
-2
votes
1
answer
48
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
- 1