All Questions
Tagged with microsoft-excel formatting
25
questions
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
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 | ...
- 1,173
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 ...
- 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
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
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.
...
- 4,174
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 ...
- 9,267
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
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 ...
- 1,467
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
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
3
votes
2
answers
10k
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 ...
- 357
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 ...
- 375
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
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