Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Convert degree from decimal number to the standard format (degre.

How to Convert degree from decimal number to the standard format (degree °
minutes ´ seconds″.
I tried custom but could not work out for some degrees.
Thanks


Post your answer or comment

comments powered by Disqus
How to Convert degree from decimal number to the standard format (degree °
minutes ´ seconds″.
I tried custom but could not work out for some degrees.
Thanks

What is the formula to correct the decimal number to the nearest even (not
odd number)number

Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul

Hi this is a complete noob question.

My Excel was crashing today while doing a Vlookup. When i restarted I notice the range references were in the format of RC e.g. row 1, column 1 would be RC[-1].

How do I get it back to the standard row and column syntax?

Cheers
Talan

I need to sort a list of numbers (and their values) by the numbers to the
right of the decimal, i.e., the list has numerous values to the left (whole
numbers), but the right have only 4 or 5 and I need these segregated by the
decimals to the right in order to put them in columns. From: 600000.3019
50
600000.3030
125
600000.6000
60
602000.3019
100
602000.3030
25
602000.6000
85
To:
600000.3019 50 600000.3030 125 600000.6000 60
602000.3019 100 602000.3030 25 602000.6000 85

I have developed a complete workbook with MTD Review, Weekly Review and Daily
Reviews. All entries are made on a daily entry sheet. Is there a relatively
simple way to convert it from month to month. I am now going through and
changing the formulas to reflect the changes in the day/week/month. There
are a total of 51 sheets in the workbook.
--
Thanks for the Help

Ken

I have a worksheet that has cells which are unprotected and then the
entire worksheet is protected. This is so users can input information
into the individual cells. My format options are grayed out, and
format _cells through the menu options is also grayed out. Therefore, I
am pretty sure that they are protected correctly. At the worksheet
level the Allow user to Change format is not checked. My problem is
that if a user accidentally hits the "/" when entering a number the
cell automatically changes a decimal number to a fraction format. This
permanently changed the format on this cell to a fraction from this
point on. Does anybody know how to prevent this from happening or how
can a user change the format back to a decimal number without
unprotecting the entire worksheet?

how do I convert numbers to the nearest 1000

Question about converting from column number to column letter:

I have a column number captured, k from:

And later in my routine I want to enter the Letter for k....

For example, if k represents column#3 i would like to get the letter C...

Seems like there should be a canned method for this, is there?

I have a worksheet that has cells which are unprotected and then the
entire worksheet is protected. This is so users can input information
into the individual cells. My format options are grayed out, and
format _cells through the menu options is also grayed out. Therefore, I
am pretty sure that they are protected correctly. At the worksheet
level the Allow user to Change format is not checked. My problem is
that if a user accidentally hits the "/" when entering a number the
cell automatically changes a decimal number to a fraction format. This
permanently changed the format on this cell to a fraction from this
point on. Does anybody know how to prevent this from happening or how
can a user change the format back to a decimal number without
unprotecting the entire worksheet?

How to convert decimal number to time : convert 1,59 (minutes, dec) to mm:ss

I AM TRYING TO FIND A WAY TO CONVERT DECIMAL NUMBERS TO WORDS I.E. 1024 TO
ONE THOUSAND AND TWENTY FOUR. IS THIS POSSIBLE???

Excel 2000
Windows 2k Pro

I need to know how I can pass values from a userform to a standard module
and vice versa.

I have a Workbook that has a custom menu from which the user can choose a
"Run Setup" option. Choosing this loads and shows a userform. One of the
controls on the userform calls a "Get_Path_and_Filename" subroutine that is
in a standard module. I'd like to return the path and file name string from
the standard module to a text box on the userform.

Should I move this subroutine to the userform module? Perhaps it's a matter
of where I declare variables? Kinda scratching my head on this one, any
suggestions appreciated.

-gk-

I've imported a series of numbers and when I save it in csv format, it
changes the numbers to the scientific format unless it's under 10 digits.
I've tried converting to text, multipling by 1, but nothing seems to keep it
formatted as a number? Each time it looks like it will work, I save it and
reopen it, only to find the numbers converted to scientific format again.

I'm completely confused as to why it won't store it as a general number if
over ten digits?
--
JR Wireless

How to have a macro in which I could register The path of the wanted data
base and the parameters I need to configur the transfer operation to MS
Acces

I tried to record the macro, I use Data/convert to MS Acces then the wizard
ask
me to convert to a new data base or an existing one . If i chose to an
existing one I have to write the path of the Acces data base to wich I want
to put Excel datas. Doing this, Excel opens Access Application and next
steps are kept in charge, I suppose, by the Access application Wizard
because it asks me to :

1- indicate if first line contain titles of columns (then press next)
2- indicate where to put data in a new table or an existing one (then press
next)
3--
4-- then to let acces add à primary key
5- indicate the table name to where i want data to be stocked
and then Terminate the importation

The macro I would like to build should replace by code actions 1 to 5 the
wishard needs to transfer Datas from Excel 2000 to the Access data base
selected (path).

Thanks

A. Lavoie, Québec, Canada

Hello,

I am trying to convert 12 digit decimal numbers to binary; example, convert 530070378301 to 111101101101010101010000001011100111101. I have found many examples for conversions but nothing that will convert anything this large.

Any help would be much appreciated.

Regards,
Jarrod

Hi there

Wondering if anyone can help me with a large amount of database work I am doing which I think can be automated somehow.

I have several databases, all of the same structure (based on the same template). Some of these have 400, some 800 entries etc. What I am doing is exporting the same few columns (A, D, E, F) into a new database, and then converting these numerical values into alphanumeric (basically just adding a letter).

Problem I have is
1. I'm not sure how to export values from one sheet to the next
2. In order to add the alpha value to the necessary cells, I am creating a side cell with the value, using a formula to combine the 2, and then doing a full select and drag right values only then drag left. When there is different amounts of data the macro I am creating does not work to the full amount.

For extra info, the original databases of same structure are to all be combined into one massive database of that same structure, they are seperated at this time as they come from different suppliers, and need some info editing. Is it easier to combine the databases first (using some sort of automated procedure) and then doing the new extraction work?

Thanks for any replies.

Simple question (i hope)

Is there a simple way i can round numbers to the nearest thousand by using
the format cells command.

For example
i would like to display 1,234.56 as 12

I don't want to be diving by 1000 and rounding to zero decimal places
because i still want the whole number displayed in the formula bar when
selecting it.

i use excel 2003

thanx
Mark

I'M USING MSEXCEL 2003 AND WOULD LIKE TO KNOW WHAT SYNTAX TO USE IN A FORMULA
FOR THE FOLLOWING EXAMPLE:

THE SYNTAX WOULD CONVERT UP AND DOWN A 4 DIGIT WHOLE NUMBER TO THE NEAREST
THOUSANDS:

4600 WILL EQUAL 5000
4300 WILL EQUAL 4000

Hello.

In a spreadsheet, I have a formula which refers to the values of a
column ('C', for instance). The first line of that column is a title, so
I currently use a range that begins with 'C2'. There is no total at the
bottom of the column. All cells that follow the last value are blank.

The problem is that the number of values on that column grows
periodically. As of now, I am using an arbitrary high value to make up
the range in the formula, e.g. 'C2:C1000'. The question is: how can I
specify that range without using a magic number? In other words, how
does one define a range that means: from this row to the bottommost row.

Thank you,

--
Ney André de Mello Zunino

I have a spreadsheet that determines the overal diameter of a cable based on
the number of conductors, insulation, shielding, etc. The result yields a
decimal number. I would like to round that decimal number to the nearest
sixteenth. I know that I can format the cell to fractions, but this does not
actually change the value. I want a new cell to have the exact decimal
equivalent of the nearest sixteenth.

For example, the first column below is the calculated "raw" diameter and
second column is the decimal number of the nearest sixteenth of the raw
diameter.

0.4687 => 0.4375
0.4688 => 0.5000
0.5312 => 0.5000
0.5313 => 0.5625
0.5937 => 0.5625
0.5938 => 0.6250

Thanks in advance for your help.

Mike

Guys, Need huge help here.

Just wondering if some could tell me how to change a decimal number to a whole number without changing the actual values.

Example,

Actual visible
A1] 0.500 -----> 500
B1] 0.365 -----> 365
Total] 0.865 -----> 0.865

See, the actual number are still the same but visually, its a whole number. All the numbers are avalible now and all in decimals, i want to change them to a whole number.

Help!

I tried aligning the numbers to the centre of the cell and decimals using
custom format #.#????, I am getting space between the first and second
decimal as seen below 100.1 2 and in 100.3 45

10.1
100.1
100.1 2
100.1
1000.3 45

What should be done to ensure there is no gap between the decimal points?

I want to be able to validate that there is a correct SSN, meaning no letters, the correct format. I tried the following but it is not working.

	VB:
	
 tbSSN_AfterUpdate() 
    tbSSN.Text = Format(tbSSN, "### - ## - ####") 
    If Format(tbSSN, "### - ## - ####") = False Then 
        MsgBox "Incorrect SSN format" 
    End If 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Now the first part of the converts a 9 digit number to the correct format, if the customer inputs 9 numbers. But, there is nothing to stop them from inputting letters or the incorrect number of digits.


No luck finding an answer? You could always try Google.