All Questions
Tagged with microsoft-excel formatting
241
questions
4
votes
1
answer
14k
views
Is is possible to apply separate formatting to multiple different Excel table columns?
I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks ...
3
votes
1
answer
2k
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 ...
3
votes
2
answers
5k
views
Open blank Excel spreadsheet with all cells in text format by default
When I paste data with leading zeroes to a newly-opened blank Excel document, it strips out all leading zeroes.
Is there a way for me to open up a new instance of Excel (not from a template, I ...
3
votes
2
answers
25k
views
Excel - "Format Cell" to display "FALSE" value in red?
Excel could define data type and format, just right click an cell and choose "Format cells...".
Inside, it seems you can define conditional format, e.g. if the value is 0 then display in red....
3
votes
2
answers
630
views
Format telephone numbers in Excel
I have a column of numbers in the format
'+43 ??? ?? ??
(the ' is there so Excel doesn't think it's a formula and ? represents an integer)
which I would like to have in the format
'+43 ?? ??? ??
...
3
votes
1
answer
5k
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 ...
3
votes
3
answers
6k
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 ...
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 ...
3
votes
3
answers
7k
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 ...
3
votes
3
answers
10k
views
Excel Graph: how can I show two values in the same bar? Not using stacked?
I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
3
votes
1
answer
9k
views
How do I make Excel display raw cell data
I have an Excel workbook with raw numeric data that probably originated as FLOAT data in a database. Looking at the xl\worksheets\sheet1.xml doc inside the XLSX shows values like this (abbreviated to ...
3
votes
1
answer
672
views
EXCEL FORMATTING NUMBERS
I have been working with my Office 2010 Plus program with no problem, for a long time.
Yesterday I started writing a new Excel spreadsheet and formatted columns for currency with no decimals I Typed ...
3
votes
2
answers
112
views
How to format text between branches excel using a macro Excel 2010
I found a little macro to change all the text between "[" and "]" red in excel.
But i can't get it to work in Excel 2010, i get some errors.
Can someone help me debug this?
At the end i wish that in ...
3
votes
2
answers
7k
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 ...
2
votes
1
answer
6k
views
Ms Excel: Is there any way to superscript a character in custom format?
I want to display the measuring unit (cubic meters) in the cell using custom format ( #.##0,00" m3"), but I want to superscript the character "3". Is there any way to do that?