All Questions
23
questions
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 ...
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, ...
1
vote
1
answer
250
views
csv file formatting issue in excel
I have a csv file when opened in notepad looks like this:
sep=,
ProgramXX, PXXXXX, ....
IDXXXXX, XYZXXXXX, ....
This should open well formatted as csv file in excel program but what I see is this:
...
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?
1
vote
0
answers
276
views
Make Excel 2007 pivot tables default to Classic View
When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...
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 ...
0
votes
2
answers
129
views
Formatting columns in microsoft excel?
I have a list (.txt document) of telephonenumbers with first and surname and number.
Like this :
123123 john doe
123132 michael jordan
etc.
I want to put the list in microsoft excel that after a ...
1
vote
1
answer
426
views
Excel does not accept custom cell format for cents
I have a spreadsheet containing cent amounts, and I am trying to format the amounts such that the last two zeroes are separated from the rest of the figure by a space, and from then on thousands are ...
0
votes
1
answer
344
views
How to find the programming done for cells / worksheets in Excel, to be able to set precision?
I have a drawing in SolidEdge software, where the dimensions of the drawing are exported to Microsoft Excel. It has a column where various dimensions of the drawing are given in various forms in every ...
1
vote
2
answers
22k
views
How to set number format to show all decimal digits
I have one excel sheet. In that one cell value $1,544.13 when i click that cell it is showing 1544.12857142857 in formula bar.
I tried to set as General, but it does not show all the digits. It ...
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 ...
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? ...
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 ...
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 ...
1
vote
1
answer
99
views
Excel Formatting Issue Without Being Administrator
Having a real weird issue. A few excel files sent to my office open fine as Administrator. However, as a standard account it opens with all of the cells shrunk and the formatting completely messed up. ...