# Tagged Questions

**1**

vote

**1**answer

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

**0**

votes

**1**answer

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

**2**

votes

**0**answers

31 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

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

**0**

votes

**1**answer

21 views

### Excel: Formatting assistance for rows with no values

I've constructed a spread sheet of people vs garment options for a year 12 jumper, the peoples names are organised in rows and the option in columns. I would really like the whole row a persons name ...

**0**

votes

**1**answer

621 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

67 views

### In excel 2010 how to colour a cell based on values from another cell

I have a quite large table with several rows and for a easy visual trace I would like that a cell change color whenever a cell in another row has value. Let me try an example to be clearer:
Say that ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

138 views

### Format number to decimal without rounding

I have numbers with decimal values in column,I want to restrict the decimal points to 3 and also want not to round the number.
To restrict the decimal places I used the format cells option.It works ...

**2**

votes

**1**answer

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

**2**

votes

**3**answers

54 views

### Adjacent cells replicate format of previous cell

I have a basic spreadsheet set up to monitor my outgoings. When something clears my account I color the relevant cell in so I know its accounted for. However since I upgraded my Office, whenever I ...

**0**

votes

**2**answers

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

**0**

votes

**1**answer

234 views

### Formula to format a cell to subtract one decimal place from another cell and have the calculated results displayed

I have a value in one cell that has four decimal places, in the cell below, I have the metric conversion formula. I want the cell below, with the metric conversion formula to display one less ...

**0**

votes

**2**answers

152 views

### Formatting Times (durations) in Excel

Does anyone have a good quick way of entering times, specifically durations, NOT time of day, into Excel? All of the times in this case will be short, minutes and seconds. Nothing as long as an ...

**2**

votes

**2**answers

209 views

### Keep Excel formatting when copying content to a text editor

I have an Excel file with a column of codes which indicate parent-child relationships with some kind of formatting:
The indent is controlled with "Indent Level" option on "Left (Indent)". Copying ...

**1**

vote

**2**answers

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

**0**

votes

**1**answer

777 views

### Why am I getting unexplained vertical lines in the center of merged cells?

I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...

**1**

vote

**1**answer

296 views

### Label's format in barchart different from the corresponding cell

I have stacked bar chart. In the label's format I checked "linked to source".
Now in the datacell,l I have this custom format "[>999999]#.##0,00.." M$";[>999]#.##0,00." k$";#0,00$". The problem is ...

**2**

votes

**3**answers

3k views

### Using conditional formatting for exact match text

I am trying to use conditional formatting to highlight cells in a column that contain an exact word with Excel 2012. I am only having partial success using "cells that contain text" function. The ...

**1**

vote

**2**answers

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

**2**

votes

**1**answer

136 views

### Is there a way to insert a formatted calculation into Excel 2010 without using an image?

I am maintaining a list of database column names, notes, and their calculations in an Excel 2010 spreadsheet. The calculations are included so as to document how to derive the values for the various ...

**1**

vote

**3**answers

8k views

### Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart?
I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...

**1**

vote

**1**answer

171 views

### Can you make a 'named' format in Excel?

Is there a way to make a named format applied to cells and then change that format and it cascade to all cells using that format? That way I can format certain numerical values and if the need ...