# Tagged Questions

**1**

vote

**1**answer

32 views

### Conditional formatting excel conundrum

I have a list of values in excel.
I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it.
Is this possible?
Thanks guys!!

**0**

votes

**1**answer

40 views

### Copy formatted tabbed table trimmed in excel

I have a texteditor logbook and need also to copy the contents into an excelsheet.
Logbook content:
01.01.2000
----------
Entry One.\t\t\t\t\t8 Hours
Entry Two.\t\t\t\t\t20 Minutes
...

**0**

votes

**1**answer

14 views

### Excel developer list box dimensions are not preserved

I used the Excel Developer Tab to create a List Box for a macro. Every time I open the file my List Box is in, the list box has shrunk. I need help fixing the width and height of the List Box such ...

**1**

vote

**1**answer

35 views

### Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...

**-1**

votes

**1**answer

42 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 ...

**2**

votes

**1**answer

278 views

### How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?

**0**

votes

**1**answer

30 views

### Excel reformatted numbers to times

I have a spreadsheet stored on a company sharepoint site. Only one person in my team will use it at any time, when they're finished it saves and is available to another user. Periodically when someone ...

**0**

votes

**1**answer

65 views

### How does Excel handle the h:mm:ss format?

I have the number 0.00082788917980126 which once converted to h:mm:ss format gives me 0:01:12, and I need to understand how as I need to perform similar formatting outside Excel, hence my question:
...

**0**

votes

**1**answer

28 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 ...

**1**

vote

**0**answers

66 views

### Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...

**2**

votes

**0**answers

34 views

### Excel 2010 clips top edge of content

In Excel 2010 on 2 different computers, the same file opens differently as follows:
Correct:
Incorrect:
The correct one is displayed first. This is a file exported from a SQL Server Report; when ...

**0**

votes

**2**answers

602 views

### How to format excel cells that show duration in years and months?

I can't figure out how to do custom formating that would format input "1/5" as "1 year, 5 months", or "5,0" as "5 years". I do want the cell to retain original input of "1/5" but visually display "1 ...

**1**

vote

**1**answer

94 views

### How to change cell format from [ss] to number without changing values

I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted h:mm:ss for the time it went in and the ...

**0**

votes

**1**answer

39 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 ...

**0**

votes

**2**answers

55 views

### Formatting columns in microsoft excel?

I have a list (.txt document) of telephonenumbers with first and surname and number.
Like this :
123123 john doe
123132 michael jordan
etc.
I want to put the list in microsoft excel that after a ...

**1**

vote

**2**answers

5k views

### Excel copy-paste: always match destination formatting

I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...

**0**

votes

**3**answers

1k views

### Newly inserted rows in a table do not get properly formatted

I am using Excel 2013. I have a table (not just a cell range, but a full table with table name, etc.). I have applied striped formatting to it. When I add new blank rows to the end of the table, they ...

**0**

votes

**1**answer

805 views

### How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?
Excel File Origin
I have an Excel file that was originally a CSV file. At this time I don't have ...

**0**

votes

**1**answer

58 views

### Format cells to percentage and restrict entering

I want to format a cell as percentage with two decimals. I used format cell and keep the decimal places as 2.
But I want to restrict the full numbers to two.
Ex:23.45%
Then I used a custom format ...

**2**

votes

**1**answer

402 views

### Use Excel Color Scale Formatting with Text

I use Excel sheets to track the status of tasks through a set of discrete statuses. I'd like to be able to format these automatically, with the start being red, the end being green and progressing ...

**0**

votes

**1**answer

20 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 ...

**0**

votes

**0**answers

68 views

### Excel Copying Conditional Formatting

I need to copy conditional formating down a column.
The values are based on VLOOKUP formulas.
When I compare J2 to F2, everything works.
When I copy the Formatting down the column, every cell is ...

**1**

vote

**1**answer

71 views

### Excel does not accept custom cell format for cents

I have a spreadsheet containing cent amounts, and I am trying to format the amounts such that the last two zeroes are separated from the rest of the figure by a space, and from then on thousands are ...

**-1**

votes

**1**answer

509 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: ...

**1**

vote

**1**answer

99 views

### Formulas and icons in Excel

In Microsoft Excel 2007 and am attempting to track vehicle mileage
I’m looking for Excel to calculate mileage until service, from two cells, and output 3 different icons or colors to been easily ...

**0**

votes

**2**answers

427 views

### Extend Excel Formula Without Overwriting Background Color

In Excel 2010, how can I extend a formula down (updating cell references) and avoid overwriting the background and fonts of the cells below it?
For example, if I have the following Excel spreadsheet
...

**1**

vote

**1**answer

52 views

### How to show 11 instead of 11.9655 in excel?

I have a formula(=O6/J6) which resulting 11.9655.
But after reducing decimal it's showing 12. I want to display only 11 and it should be without decimal.
It should be look like this:-
...

**0**

votes

**1**answer

42 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 ...

**0**

votes

**1**answer

30 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 ...

**0**

votes

**1**answer

117 views

### How to find the programming done for cells / worksheets in Excel, to be able to set precision?

I have a drawing in SolidEdge software, where the dimensions of the drawing are exported to Microsoft Excel. It has a column where various dimensions of the drawing are given in various forms in every ...

**0**

votes

**0**answers

178 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 ...

**1**

vote

**2**answers

4k 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 ...

**0**

votes

**1**answer

892 views

### excel custom number formatting - only show decimals when there are not whole numbers

Is it possible to format numbers (or currency) in Excel so that there will only be a period when there is not a whole number? For example:
12.43 will appear as 12.43
12 will appear as 12 and not ...

**0**

votes

**1**answer

534 views

### Can I paste rich text and preserve formatting?

I have an Excel sheet and I paste text into a text box. I'm trying to copy+paste a source code from Eclipse and to preserve syntax highlighting and preserve tabs (code formatting).
Syntax ...

**0**

votes

**1**answer

55 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.

**3**

votes

**1**answer

341 views

### Show only the LAST few characters of a cell when data is to wide in MS Excel

I have a sheet that contains a column of xpath expressions (these resemble file paths.) For the most part the first 50 or so characters are always the same. This causes the data to be unhelpful when ...

**0**

votes

**2**answers

6k views

### Is it possible to copy an excel column into another sheet including data, formatting, and all and have it update when the original changes?

I have a sheet in excel that has 40 rows, with some information in each row,
A B
Nate 32
Bob 28
Cheryl 65
John 34
Candy 23
I have manually highlighted ...

**0**

votes

**1**answer

2k 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, ...

**-1**

votes

**1**answer

465 views

### How to set number format to show all decimal digits

I have one excel sheet. In that one cell value $1,544.13 when i click that cell it is showing 1544.12857142857 in formula bar.
I tried to set as General, but it does not show all the digits. It ...

**1**

vote

**2**answers

10k views

### How to disable Excel number autoformat

This problem is simple to correct but is very very annoying
what I'm doing is to type a hour range, eg. (0-1),(1-2),(2-3) so on
per cell row
DATE --- HOUR
1/1/2013 0-1 1/1/2013 1-2 ...

**2**

votes

**3**answers

4k views

### Excel text alignment with custom formatting

Is there anything in a custom formatted formula which defines the text alignment?
I know the different parts of the formula is numbers, negative numbers and so on, but I need to set the alignment.
...

**1**

vote

**0**answers

110 views

### Maintaining subscript format when copying a cell

How do I copy/lookup/drop down list a cell with subscript format?
EXAMPLE:
Phosphate (P2O5) should have the 2 & 5 in subscript but always returns without it.

**5**

votes

**3**answers

7k views

### why does an Excel column formatted as number lose its leading zero when the column is formatted as text?

I have to export a spreadsheet to CSV. One of the columns is a zipcode with east coast zipcodes that have a leading zero. When I reformat that column as Text hoping to preserve the leading zero on ...

**0**

votes

**1**answer

986 views

### How can I copy cells in Excel 2007 and paste with formatting

I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook ...

**2**

votes

**4**answers

461 views

### Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?

Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...

**1**

vote

**2**answers

348 views

### How to format date dynamically in Excel 2010

Could anyone help me to provide the format as below. You can use Macro, if you want to format, else if any other easy step, tell me. I searched other threads and all refer to specific cells, but I ...

**4**

votes

**1**answer

409 views

### Excel keeps adding hyphens within words when pasting

I'm transferring data from another document to an Excel document. Everything was proceeding as expected but at a certain point, anytime I paste something, Excel adds hyphens within words using the ...

**1**

vote

**2**answers

325 views

### Formatting a cell in Excel - how to show a symbol in a specified position

When formatting a cell in Excel (or LibreOffice), how can I have a certain symbol displayed in a specified position?
For instance, I want a cell formatted so that the sixth symbol is a hyphen, eg. ...

**3**

votes

**3**answers

3k views

### In Excel Sheet how to convert the date format of a cell to general format when its value is changed from date to text(or number)?

I find this very strange in excel sheet (or may be its just me), by default all the CELLS in the excel sheet are in GENERAL format (G) and when I enter date value (1/1/2012) in a cell the format gets ...

**1**

vote

**1**answer

111 views

### Changing cell color based on its contents

I have a list of car dealerships. What I'd like to do is change the color of the cell based on what type of dealership it is. So, for example, if I have the cells:
ABC Ford
DEF Chevrolet
GHI Honda
...