0
votes
0answers
20 views

Excel Format Cells Oddly Not Working

I want to format the number : 100007878 to be displayed like : 1 0000 7878 But when I put : # #### #### in Excel's formatting formula, I've got the following result : 100 007 878 I've ...
0
votes
2answers
310 views

Convert a number stored as text to a number

I'm using Excel 2010, and have a spreadsheet of simple numbers (they're 1-5 ratings for a range of questions), so I have questions across the top, and each person's responses as a separate row. The ...
1
vote
1answer
207 views

Avg times in mm:ss.0 format

I have a range of times formatted as mm:ss.0. The problem is trying to average these times. Time AVG 2:44.35 2:42.88 2:47.49 2:48.86 2:56.31 00:00.0
1
vote
2answers
4k views

How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...
1
vote
1answer
62 views

Excel 2010 - formula that formats a cell in function of another cell value

Can i have a formula that formats a cell in function of another cell value. Lets say, if A1=1 all the values in column B are formatted into dollars. If A1 different than 1 then all the values in ...
0
votes
0answers
44 views

Format issue with dates over the 13 in excel

I have the following problem. I'm not able to modify all dates older than the day 13. For example: With the date 07/01/2013 11:20:00 I am able to change the format. To 07/01/2013 11:20 a.m. But with ...
0
votes
1answer
5k views

How to copy the value and format of a cell into another cell on Excel 2010? [duplicate]

I have been looking all over the internet for this question, but it has not been answered by anyone. I am, on Excel 2010, trying to copy (not copy and paste) the format AND value of a cell, onto ...
2
votes
1answer
5k views

How can I change the default date format?

When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0". I know I can work ...
1
vote
1answer
1k views

How can I zebra-format rows in Excel 2010 automatically?

I've got a long list of data (export from MySQL) that I want to print out to tick each row after I've done stuff with it. Is there an easy way in Excel 2010 on Windows to make the table ...
0
votes
1answer
392 views

Making chart from custom data format in Excel 2010

I am defining custom data format via Apache POI. I know I need to use following construction: DataFormat data = this.workbook.createDataFormat(); ...
1
vote
1answer
144 views

Copy text value and formatting to another cell

I have to call the text value of cell A1 using index+match function to A2. A1 contains two fonts – Calibri (11) and Times New Roman (20). I want to get the same text format in cell A2. How can I ...
2
votes
2answers
1k views

How to have Excel show numeric values as custom “currencies” (eg. copper, silver, gold)?

I would like to have the following format in a cell in Excel: 123g 99s 99c 100 copper (c) = 1 silver (s) 100 silver = 1 gold (g) So that, if I enter 12394 it'll be shown as "1g 23s 94c". Is that ...
11
votes
10answers
38k views

Why does Excel treat long numeric strings as scientific notation even after changing cell format to text

I'm trying to process some data in Excel. The data includes numeric account numbers and other long numeric strings (like cell phone MEIDs). I am not doing math operations on these strings, so I want ...