All Questions
23
questions
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 ...
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 ...
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, ...
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? ...
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 ...
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
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
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 ...
2
votes
1
answer
5k
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
5
answers
41k
views
Protecting the formatting in Excel 2007
I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've ...
2
votes
2
answers
11k
views
How do I filter on bold, struck through or italic text in Excel 2007?
Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?
2
votes
5
answers
8k
views
Excel sheet - automatic formatting
I want to configure automatic formatting for my Excel datasheet.
Here's have an example (not mine):
How can I automatically format the rows depending on one of its cell's values which is not a ...
1
vote
5
answers
61k
views
Add more than 20 digits in Excel without an exponential sign [duplicate]
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
1
answer
1k
views
How to change cell format from [ss] to number without changing values
I am doing my Msc Ecology thesis and in the process of organizing my data set. When inputting my data for the amount of time a skink spent in a hole I inputted h:mm:ss for the time it went in and the ...