# Tagged Questions

**0**

votes

**0**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**10**answers

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 ...