1
vote
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
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
1answer
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
1answer
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
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
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
0answers
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
2answers
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
2answers
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
1answer
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
2answers
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
1answer
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
0answers
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
2answers
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
0answers
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
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 ...
0
votes
3answers
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
3answers
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
2answers
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
5answers
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
1answer
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
3answers
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
1answer
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
5answers
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 ...