1
vote
1answer
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
1answer
28 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
1answer
11 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
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 ...
-1
votes
1answer
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
1answer
175 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
1answer
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
1answer
62 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
1answer
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
0answers
61 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
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
481 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
1answer
87 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
1answer
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
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 ...
1
vote
2answers
4k 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
3answers
840 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
1answer
641 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
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 ...
2
votes
1answer
374 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
1answer
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
0answers
62 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
1answer
70 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
1answer
483 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
1answer
98 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
2answers
374 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
1answer
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
1answer
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
1answer
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
1answer
113 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
0answers
170 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
2answers
3k 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
1answer
782 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
1answer
485 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
1answer
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
1answer
322 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
2answers
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
1answer
1k 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
1answer
418 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
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 ...
2
votes
3answers
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
0answers
108 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
3answers
6k 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
1answer
929 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
4answers
453 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
2answers
337 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
1answer
396 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
2answers
309 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
3answers
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
1answer
110 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 ...