Tagged Questions

0
votes
0answers
18 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
52 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
53 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
39 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
43 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.
2
votes
1answer
45 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
1k 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
107 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
106 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 ...
0
votes
1answer
514 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 ...
1
vote
3answers
229 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
67 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.
3
votes
3answers
529 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
165 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
180 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
224 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
207 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
101 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
987 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
96 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 ...
0
votes
1answer
898 views

Need an excel macro to produce a formatted text file

I am just learning how to make macros and I found a macro that nearly does what I need it to do, which is output a text file from Excel. What I need it to do is output this in a .mhd format, which I ...
0
votes
1answer
299 views

Race times not formatting correctly

I do triathlons (short ones). For each race I get 6 results: mm:ss for the swim mm:ss for the transition between swim and bike mm:ss for the bike mm:ss for the transition from bike to run mm:ss for ...
2
votes
1answer
427 views

IMEI number formatting in Excel

I'm trying to format IMEI numbers in Excel according to RIM (Blackberry) conventions: XXXXXX.XX.XXXXXX.X I enter them in excel without any periods and use the "special format" cell properties so it ...
2
votes
2answers
2k views

Excel VBA Function for Value AND Format Lookup

I need a custom function to lookup both a cell value and copy the source format. I have a list of values in two columns. The first is of integers and the second column is the corresponding text ...
0
votes
1answer
718 views

Large Number, Abbreviated Formatting

Consider the following scenario. I have a data column that contains a large list of numeric, whole number values. Some of these values are comparatively small (i.e. 1,000) while others are very ...
1
vote
2answers
3k 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 ...
6
votes
2answers
1k views

Excel elapsed time format

In Excel, given a number representing some amount of time (e.g. 25.5 hours), is there a way to format it so that it shows as 1d 1h 30m? Bounty question : Is there a way to add months to this format? ...
1
vote
1answer
115 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 ...
5
votes
3answers
8k views

How to stop Excel from Auto-formatting and making it work like a number crunching program

I have a real problem with Excel in csv files where it is formatting numbers in certain ways and I cannot seem to get Excel to display the data right no matter what I do. Imagine I have a colum ...
15
votes
7answers
11k views

How to copy multi-line text from Excel without quotes?

When you create a multi-line string in an excel cell (by using Alt-Enter), if you copy that cell to a text editor, excel will automatically add double quotes (") around the full string, ie: Cell1 | ...
2
votes
1answer
351 views

Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string

I had a followup question to this related post - Formatting a CSV to force Excel to interpret value as a string (not date or number) I was wondering how does one escape text starting with " using ...
8
votes
4answers
6k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

Searching around for a while trying to figure out how to format a CSV file in such a way to force Excel to interpret the values as a string and not try and convert them to numbers or dates. e.g... ...
4
votes
1answer
7k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
13
votes
9answers
17k views

How can I set Excel to always import all columns of CSV files as Text?

Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only ...
1
vote
1answer
56 views

How can I display a '+' or '-' sign in front of a result using cell formating?

I'm subtracting figures and I need to show whether the result is negative or positive. Stumped as to how to make the '+' or '-' sign appear using cell formatting. Minus is automatic, I presume, but ...
1
vote
2answers
383 views

Macro for helping superscript last character of many rows in a single column

I'm adding footnotes (always adding footnotes) to a table and I would really like to be able to automate the repetitive nature of making my symbols superscript. Currently it’s: >enter cell>highlight ...
3
votes
7answers
6k views

Opening CSV file in Excel corrupts telephone number column

I export listview data to csv file. There is a column, 'Contact No'. This column's data type is 20 field size of text in MS access. Opening this csv with Notepad, it shows the actual data value, ...
1
vote
3answers
2k views

How to set a character limit and remove characters over that limit excel 2007

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max. I have a list of ...
8
votes
1answer
7k views

Why won't my Excel columns hold the cell format I enter?

I have a spreadsheet which has data linked in from other tabs on the same spreadsheet. Each of the source tabs has a column formatted as a number with no decimal. The tab they're linked to has the ...
2
votes
1answer
289 views

Why are some blank cells seen as zero in Excel?

We have Excel documents that date back years. Some of the document sheets haven't been touched for over 15+ years (or to the very early versions of Excel). They've had a new sheet added each year - ...
0
votes
2answers
2k views

Paste to Excel from clipboard (plain text) : Can I make certain cells to be formatted “as such”

when preparing table data as text to be copied to Excel through clipboard, is it possible to have certain cells unformatted? (If possible, without changing Excel settings or doing a special paste). ...
3
votes
2answers
868 views

Format restrictions for cell in Excel

I want a cell to only have a specified format, e.g. "01-02-03", meaning "double digit dash double digit dash double digit". I a user tries to enter something into the cell, an error should occurr ...
5
votes
2answers
330 views

How can I specify a sheet as range in Excel?

I want to apply conditional formatting on a sheet. I used to do Ctrl + A and then apply the formatting, but when i insert new cells or rows, this isn't included in the formatting. As you can see in ...
0
votes
1answer
189 views

Excel: is it possible to extract a superscript letter from a word?

I'm wondering if these is a way of using a formula to find a superscript letter, rather than just the last letter of a word. I have lots of tabs, with nearly matching tables on each one showing up to ...
1
vote
1answer
64 views

Excel Formatting Issue Without Being Administrator

Having a real weird issue. A few excel files sent to my office open fine as Administrator. However, as a standard account it opens with all of the cells shrunk and the formatting completely messed up. ...
0
votes
1answer
689 views

In Excel, how do I prevent the cell's formatting to be dragged along?

When working with data, drag-and-drop can dramatically speed up the workflow. Sometimes we work on files which already have their formatting in place, such as borders and colors. When I want to move ...
0
votes
4answers
171 views

How to configure and move text in a raw text file including keeping spaces

What I need to do is move a column of text over to another part of the file; however, each line needs to be a specific amount of spaces at the end and I cannot copy the lone column over because it ...
0
votes
1answer
2k views

Excel: convert text string to date/time format

I have a column with date/time info in following format stored as text: 03.01.2011 09:55. How can I convert it to Date/Time format?
1
vote
2answers
5k views

Add more than 20 digits in Excel without an exponential sign

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, and it converts the number to an exponential format. I tried with a number format and accounting, but ...
1
vote
1answer
339 views

Format Million on Excel 2007

I would like to change the format predefined with Excel 2007 for million in the previous versoin I could do that but havent found a way to do this. For example I have this: 1,235,000,00 and I ...

1 2