All Questions
Tagged with microsoft-excel formatting
240
questions
135
votes
6
answers
326k
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.
...
107
votes
23
answers
247k
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 | ...
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 ...
67
votes
11
answers
262k
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 ...
38
votes
16
answers
309k
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 ...
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 ...
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 ...
20
votes
12
answers
166k
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 ...
18
votes
8
answers
155k
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 ...
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 ...
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?
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 ...
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 ...
11
votes
2
answers
112k
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, ...
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 ...