All Questions
Tagged with microsoft-excel formatting
241
questions
135
votes
6
answers
327k
views
Formatting a comma-delimited CSV to force Excel to interpret value as a string
I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates.
...
- 4,174
107
votes
23
answers
248k
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 | ...
- 1,173
82
votes
10
answers
209k
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 ...
- 942
67
votes
11
answers
263k
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 ...
- 9,267
38
votes
16
answers
310k
views
Excel displays ### for long text - what's wrong?
We've got an excel sheet with a pretty long text in one cell. Instead of line breaks (as set in the cell format), we get a long line of ####s. We can go back and forth by deleting and adding chars at ...
- 529
26
votes
4
answers
301k
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 cells having a distinct value a unique color without manually creating a conditional format ...
- 28.1k
25
votes
8
answers
161k
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 ...
- 465
20
votes
12
answers
167k
views
How to prevent cells from printing in Excel
How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...
- 1,467
18
votes
8
answers
156k
views
Merging two cells in multiple rows
I have an excel spreadsheet with two cells in each row that I'd like to merge. Highlighting all the cells of interest and just merging from the cell formatter seems to just merge all the cells ...
- 375
18
votes
1
answer
74k
views
Stop Excel chart from changing series formatting
I have an Excel bar chart that is formatted exactly the way I like it. The bar colors, the label fonts, the grid lines, etc, etc.
Here is an example:
Notice the awesome formatting of the second ...
- 454
17
votes
1
answer
251k
views
How to concatenate a date in MS-excel and receive a date (not a number)
When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006).
How can I display the date also in the formula cells?
- 756
13
votes
8
answers
62k
views
Table Formatting in Excel 2007: How do I remove it?
I've used the new Table Formatting option in Excel 2007. Now I can't remove it. I've dragged the little blue square up to the last cell on the top left, but it just won't go any further. In fact it ...
- 1,538
13
votes
4
answers
140k
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/1/2013 ...
- 233
11
votes
2
answers
113k
views
How do you format numbers in Excel for Indian Currency (Rupees)?
Currently the Excel default formatting is:
1,000,000
500,000
How do you format the number to use the comma separator (,) like this
10,00,00,000
50,00,000
This is is how Indian Currency (Rupees, ...
- 181
10
votes
2
answers
33k
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 ...
- 1,689
8
votes
3
answers
7k
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? ...
- 550
8
votes
7
answers
91k
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.
...
- 213
8
votes
3
answers
19k
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 ...
- 81
7
votes
6
answers
132k
views
how to change 0's to -'s for a selected block of cells
I want to change the formatting on an excel sheet so that 0's will show up as dashes for only a specific block of cells on a sheet. Does anyone know how to do this?
Note that I do not want this ...
- 581
6
votes
8
answers
37k
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, ...
- 161
6
votes
7
answers
44k
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 ...
- 302
6
votes
3
answers
35k
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 ...
- 1,537
6
votes
1
answer
627
views
Why is Outlook Formatting this Column Header into text wrapped (2 lines) when pasting from Excel and how can I stop it?
I'm trying to spend a moment to figure out how to block Outlook from messing with my tables each time I paste one. Basically, each time, I have my data so there is no "text wrapping" and its ...
- 1,455
6
votes
3
answers
19k
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).
...
- 272
5
votes
7
answers
353k
views
Adding a zero before values in an Excel spreadsheet column?
While trying to fill in social security numbers into Excel 2007, my dad found out that he couldn't make the numbers start with a zero (0).
Example: 0123456789 is turned into 123456789
What do I need ...
- 24.8k
5
votes
5
answers
18k
views
Is there a way to use Conditional Formatting on a row based on values in a single column? [duplicate]
Possible Duplicate:
Conditional formatting to highlight the whole row
I have a sheet to be conditionally formatted. I want to format the whole row based on key text. Is it possible?
EvoWinds
5
votes
5
answers
168k
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 names/...
- 2,097
5
votes
2
answers
36k
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
...
- 6,080
4
votes
4
answers
23k
views
custom format for cells with nothing in them without using conditional formatting
if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...
- 983
4
votes
3
answers
3k
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 ...
- 323