All Questions
23
questions
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
461
views
Format Million on Excel 2007
I would like to change the format predefined with Excel 2007 for million in the previous versoin I could do that but havent found a way to do this.
For example I have this:
1,235,000,00
and I ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...