1
vote
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
3answers
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
1answer
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 ...