# Tagged Questions

**1**

vote

**0**answers

20 views

### When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...

**-1**

votes

**1**answer

40 views

### How to count two different column?

I really need your help regarding the below table, I need a formula to show me how many pending/closed for each project.
Project Status Project Pending Closed
VIVA closed ...

**0**

votes

**1**answer

83 views

### Coloring separate rows based on matching of data in key cell

i have a excel file as
i want change the sheet that after sort on key column(MasterID), any rows same as key column change color to similar.
for example

**2**

votes

**1**answer

438 views

### Excel TEXT function does not work properly

Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : ...

**0**

votes

**1**answer

166 views

### How do I prevent Excel from changing the color of a clicked link?

I'm using Excel 2010. And as most Excel users know, if a cell is also a link, once you click it it turns to this awful purple color. For me this ruins the color coding I'm using to show the status ...

**0**

votes

**0**answers

67 views

### Strange issue with formulas and cells in Excel 2013

So I'm having these very strange excel issues with Excel 2013. I'm typing away, but then all of a sudden certain cells' fonts have more spacing between letters and when those cells contain numbers, ...

**1**

vote

**2**answers

202 views

### Excel macros date format worldwide

On a Mac Mountain Lion, US locales, I'm working on a Spreadsheet with macros like
TEXT(TODAY(), "yyyy-mm-dd")&" is the date"
The problem is that the sheet is also used on computers set with ...

**0**

votes

**1**answer

906 views

### Excel - Convert currency as text to numbers

I frequently copy and paste HTML tables into Excel to do quick aggregate operations (e.g. sums, averages, etc).
In this example, PayPal, their HTML table contains text values like
A | B ...

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

**1**answer

38 views

### custom scientific format in excel

In microsoft excel, I want to use the scientific format for a number. However the built-in format will the number with one digit in the left of the point.
For example, it shows 2000000 as 2.0E+6. ...

**1**

vote

**1**answer

376 views

### Excel export with specific csv settings?

I'm a newbie to excel and csv files.
I have a excel file with the following structure … http://cl.ly/Rdkp
user_login user_email user_pass first_name last_name display_name role
Some Name ...

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

127 views

### Excel: Align by decimal point in cells with stars

In Excel 2011 for Mac, I have the following column of numbers:
0.139**
-0.131**
-0.135*
-0.053
0.139**
0.112*
0.183***
Some items are negative, and some have stars.
My goal is to have the column ...

**0**

votes

**0**answers

61 views

### How do I change default decimal places when opening dbf files in excel?

When I open dbf files in excel the numeric fields are automatically displayed with 4 decimal places. This is not the default number of decimal places for an excel numeric field, so changing my Normal ...

**0**

votes

**2**answers

148 views

### Excel 2010 > Chart Axis Formatting

I have a chart that has a primary and secondary headings. But, in the chart I can't find a way to just bold the primary heading. The table that the chart is created from has the primary headings ...

**1**

vote

**2**answers

209 views

### How to import this data set into excel? (column headings on each row delimited by a colon)

I'm trying to import the following data set into Excel. I've had no luck with the text import wizard. I'd like Excel to make id, name, street, etc the column names and insert each record onto a new ...

**1**

vote

**1**answer

28 views

### MS Excel: custom money format

Need to represent decimal number as "## hrn. ## kop.".
Example:
1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.
I've created custom cell format:
0," hrn. "#0" kop."
Result is:
1.2 => 1, hrn. ...

**0**

votes

**2**answers

126 views

### How to get Excel to save date fields as displayed.

I have data that has date-time values that I need to convert to a different format. I have created an Excel formula that concatenates the string into exactly the format I need. I currently have the ...

**0**

votes

**1**answer

63 views

### Excel predefined format accident

Hi everyone I have a serious problem with my spreadsheet (xlsm)
I don't know how, but cells with default format were converted to currency $, for example C12 has 123, now is $123.00.
How I can ...

**1**

vote

**0**answers

438 views

### What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats.
I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...

**0**

votes

**2**answers

922 views

### Make a number display without decimals and rounding in Excel

I want to just enter a number for the amount of inventory we have. I do not want decimal places and I want to type in the number without it rounding.
For example when I type in 6, it reads as 0.06 ...

**1**

vote

**0**answers

140 views

### ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

I haven't been able to find an answer to this.
I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...

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

**0**

votes

**3**answers

1k views

### How to stop automatic conversion from text to hyper links?

How to stop in Excel automatic conversion from text to hyper links with formatting style?
I know that this feature is good in most cases, but I work on report creation and I have problem with long ...

**1**

vote

**3**answers

691 views

### How can I convert non-standard date data in Excel?

For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...

**2**

votes

**2**answers

2k views

### Merging duplicate rows in Excel 2003

I have a spreadsheet with two columns in the format:
title A 300
title B 345
title A 25
title C 105
I would like to merge the rows with duplicate titles while totaling the numeric value so ...

**1**

vote

**5**answers

3k views

### Is there a custom format in excel to show cents values without a decimal

I would like to display 0.37 as 37¢, in Excel. I can do .37¢ with the format .00¢, but 00¢ doesn't work, cause it works with the whole number part.
I know the percentage sign works with the next two ...

**2**

votes

**1**answer

1k views

### Excel graphs: I have created a template graph format but how do I apply it?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...

**0**

votes

**3**answers

331 views

### How to protect Excel cell contents

How can I protect Excel cells contents in a worksheet and also in its xml file format?
I want the cells to be read-only.

**1**

vote

**1**answer

335 views

### Import exponetial fixed width format data into Excel

I've received a bunch of text data files consiting of Lots of records (>30K/file) of 3 fields each of 5-place numbers in exponential format: s0.nnnnnEsee (where s is +/-, n is a digit and ee is the ...

**3**

votes

**5**answers

26k views

### Excel: copy cell formatting in equation

If I make an equation:
' on cell A2
=A1
Is there a way to make A2 have the exact same formatting as A1 and not just the value?
EDIT:
i.e. I want a FORMULA that copies both the value and the ...