Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Keyboard Shortcut To Increase Or Decrease The Number Of Decimals


Is there any keyboard shortcut to increase or decrease the number of decimals shown directly (I mean without having to use ctrl + 1... etc )


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Getting A Value To Increase Or Decrease Number Or Rows...
I need to be able to select a certain number (from, say, 1-20) from a drop down menu, which will decide a number of rows (filled with data) on the next sheet. As I prefer not to give anyone the sheet I'm actually working on I made a quick look-a-like which might explain this better.

A and B are different scenarios, with different values in the fake drop-down menu I made. Just to pass on the understanding of what I want the values to do. If putting a drop-down menu there is troublesome, then I can live without them. But entering a certain value in the field and getting that number of rows for a certain product is what I need. I tried searching for a function/macro to use for this, but I dont know what exactly to look for. Name, etc

View Replies!   View Related
Format Number To Increase/decrease
How can i format my excel spreadsheet cell so that a number

10,000,000

displays as

10

View Replies!   View Related
% Of Increase - Decrease - Formula
Simplified:
I have a this years total in A1, last years total in B1, difference +/- in C1

$1000.00___$800.00___+$200.00___+%
$800.00___$1000.00___<$200.00>___<%>

I am trying to get a % of Increase/Decrease (Between A1 and B1) in D1.
Not as a dollar amount but as a %.

I have tried Percentile and PercentRank and some other stuff. No joy.

View Replies!   View Related
How To Count Decrease To Increase Match
Below i have example table in which Cells B2:G4 have draw numbers. In Cells I2:X4 I have numbers in 3 groups, Group start with small number and finish with highest number.

For example in row 2 first groups is 5 to 36, second group is 10 to 30 and third group is 4 to 41 and continue same for rest rows ....

View Replies!   View Related
Increase/decrease Values Individually?
I have a single simple question, so let's get straight to the point: I have an A column with these values:

I:::I::::::A::::::I::::::B:::::....
I==================== ....
I 1 I____40____I_________ ....
I 2 I____50____I_________.....
I 3 I____30____I_________.....

And I need each of these values increased/decreased by a constant number.

So far, I only found formulas where all cells are, say, added into a single result, as you can see here:.....

View Replies!   View Related
Increase/Decrease Times By X Hours
in speeding up the below code as it does not seem to matter whether I use For, If loop etc - it runs too slowly. Basically we have one sheet which is input in a different timezone that needs converting to GMT... since daylight saving I wrote some code to cover the +/- 1 hour difference (this seems to work quite well) yet when it comes to converting the actual cells it runs incredibly slowly. I appreciate any help but its only the code after "Sheets("data").Unprotect" that i think needs changing. The time stamp is in column 7 - I hope this makes enough sense - which then gets converted by either 4.5 or 5.5 hours dependent on british summer time.

Sub TimeConvert()

With Application
.Calculation = xlCalculationAutomatic
. ScreenUpdating = False
.DisplayAlerts = False
.EnableEvents = False
End With

Dim FirstDate As Date
Dim Position, DayIndex, lgrow, lstrow As Long, TargetMonth As Long, Stweekday, Enweekday, Tdate As Date, TargetYear As Long, cell As Range
Dim bst As Boolean

TargetYear = Year(Now)
TargetMonth = 3
Position = "L"
DayIndex = 1

View Replies!   View Related
Change Cell Color After Every Decrease Up To Increase
I have a 49 numbers in cell A1:AW1 they are not in acceding order. I want to separate all groups start from lowest number to highest giving them deferent color. As shown in example table below in cell (A2 start with n 6 and increase up to n 47 till cell F2 =yellow color) then Cell (G3 decrease n 3 and increase up to n 49 till cell L49=Green Color) and continue same process for rest ....

View Replies!   View Related
Command Button Size Increase / Decrease
I'm building a keypad out of commandbutton controls, and there's this strange resizing behavior with the commandbuttons. I've attached an example, as it's much easier to see than describe.... but essentially, clicking a button seems to enlargen it slightly, and then two clicks later, it 'dezooms' back to original size (even with shadows turned off). while this is not hugely noticeable individually, it feels really strange when there's a whole keypad of commandbuttons.

View Replies!   View Related
Keyboard Shortcut To Insert A Row
keyboard shortcut to insert a row.

View Replies!   View Related
Formula To Change Cell Colour :: Due To Sum Increase Or Decrease
how to change the cell colour due to a sum increase or decrease? For example: if the amount is greater than 200, change cell colour to green. If under 200 change cell colour to yellow.

View Replies!   View Related
Spin Button To Increase Or Decrease By 1 Each Time It Is Clicked Up Or Down
I am having difficulty finding information on coding my spin button on a user form. I searched and haven't found any information. I need to do is code a spin button to increase or decrease by 1 each time it is clicked up or down. I would like it to populate to a text box on my form if that is possible.

View Replies!   View Related
Keyboard Shortcut For 'Paste Special'
Need keyboard shortcut for 'Paste Special'

View Replies!   View Related
Select All Sheets/keyboard Shortcut
Does anyone know the keyboard shortcut to select all sheets.. without creating a macro?

View Replies!   View Related
Keyboard Shortcut To Rename Worksheet
Is there a keyboard shortcut to select the name of the active worksheet? At the moment I have to double click on the [Sheet1] and then retype.

If there isn't, is there a macro which can select the name of the active worksheet?


View Replies!   View Related
Keyboard Shortcut For Switching Through Worksheets
I need keyboard shortcut for switching through worksheets.

For now, I have this VBA macro and shortcut Ctrl+R:

View Replies!   View Related
Adding A Keyboard Shortcut In A Macro
How can i add a keyboard shortcut in already saved macro. Is there any way to do it or need to write a new macro?

View Replies!   View Related
Keyboard Shortcut: Copy Formula
Is there someone who know the keybord shortscuts for copy a cell formula, whithout using mouse. Like this: A1: =VLOOKUP(I2;A:A;1;FALSE)

Then copy the cell formula to the end of the sheet:

A2:=VLOOKUP(I3;A:A;1;FALSE)
A3:=VLOOKUP(I4;A:A;1;FALSE)
A4: =VLOOKUP(I5;A:A;1;FALSE)

With the keybord.

View Replies!   View Related
Keyboard Shortcut To Resize Columns
I am looking for is a keyboard shortcut to resize a column to fit the largest text entry in that column. Currently I am using the mouse and double-clicking between columns.

View Replies!   View Related
Keyboard Shortcut To Select A Row And Delete It Without Using Your Mouse?
is there a keyboard shortcut to select a row and delete it without using your mouse?
select a row and delete it without using your mouse?

View Replies!   View Related
Replace Keyboard Shortcut For Macro Dialog
I would like to replace the keyboard shortcut for the macro dialog box
The standard Alt + F8 is on the right side of the keyboard

I would like somethine of the left side such as Alt + Q

View Replies!   View Related
Keyboard Shortcut For Paste Special Values
Is there a short- cut key sequence for paste special value short of: Alt+E+S+V

or

Writing a subroutine in Personal.xls and giving it a shortcut key like:

Sub PasteValues ()
Selection.Formula=Selection.Value
End Sub

View Replies!   View Related
Keyboard Shortcut To Highlight All Cells In A Column From Bottom To Top
What is the best way to highlight all cells in a column from bottom to top?

For example, if I'm in column O, row 138, what keyboard shortcut would I need to select ONLY and ALL cells from the row I'm currently on, (in this example, 138) to row 1 and ONLY in that particular column?

Keep in mind that the next time I may be starting at row 1,200, it could be different everytime.

I tried everything I could think of..


CTRL+A
CTRL+SHIFT+A
CTRL+HOME
CTRL+SHIFT+HOME
CTRL+UP ARROW
CTRL+SHIFT+UP ARROW
CTRL+PAGE UP
CTRL+SHIFT+PAGE UP

and nothing worked to select everything in that column from the row I'm currently on, to row 1.

View Replies!   View Related
VBA Code To Create A Paste Special Values Keyboard Shortcut
I have written a short VBA code to create a Paste Special values keyboard shortcut.

Is there a way or a place that I can put this code so that every time I open any workbook in Excel, or open Excel itself that this VBA code will be active and I can use the keyboard shortcut?

View Replies!   View Related
Increase In Decimals Returns Strange Result
I have discovered a strange thing about excel and it is driving me mad and ruining my project.

Basically, If i enter the number 97.4 into cell A1 and then 97.165 into cell B1 and then enter the formula =A1-B1 into cell C1 i get the answer 0.235. Which is correct.

However, when you increase the number of decimal places to 30 the answer that is returned is 0.234999999999999000000000000000.

This calculation result seem to fluctuate wildly depending on the primary numbers in cells a1 and b1. Very rarely have i seen the full 30 decimal places without a bizarre result like this.

Maybe it has been too many years since i was at school and that i am confused with my numbers and that there is a real easy answer to why this result is returned.

As i said it is ruining my project that i am working on. Can anyone help? Why does excel do this? Is there a way to stop this happening? My project relies on this answer to be correct. Is there a way to force excel to stop doing this?

View Replies!   View Related
Number Format (4 Decimals Places) In VBA
I am having an issue with number format in my VBA code. The entire column of column D is format as ###.0000 (4 decimals places). There are certains cells which require zero decimal places. I am using the following bit of code, but it is not working correctly. It is still formatting the cell as 4 decimal places.

View Replies!   View Related
SpinButton To Increment By Decimals Not Whole Number
Im using this code to change the value of an active cell with a spinner named: 1.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lNum As Long
If IsNumeric(Target) Then
lNum = Target
If lNum = Target And Target >= 0 Then
With Me.Shapes("1").ControlFormat
.LinkedCell = vbNullString
.Value = Target
.LinkedCell = Target.Address
End With
Else
Me.Shapes("1").ControlFormat.LinkedCell = vbNullString
End If
End If
End Sub

The problem is, that whenever I click or activate a cell its value automatically changes to 0. The spinner works just fine modifying the value of the activated cell. The problem is that this code somehow causes all the decimals such as 0,3 0,1 or 0,8, entered manually, to change to 0. This way only integral numbers, such as 1, 45 or 100 are accepted. I must truly say I have no [no need to swear - mod] idea how to fix these problems meaning the automatically inserted 0 and the fact that the sheet doesnt accept decimals changing them to an integral number.

View Replies!   View Related
Alter The Number Of Decimals In A Custom Format
is there any way by which you can alter the number of decimals in a custom format using just custom format process (ie no VBA).

For ex:

12 should appear as 12
12.1 should appear as 12.1
12.26 should appear as 12.3

Note 12 should NOT appear as 12.0

So point being adding the "m" is an irrelevance at this time - the key is to vary the decimal points essentially based on MOD(value,1) = 0

If you can (I'm really thinking you can't) let's extend it such that 12.1 should appear as 12.1 but 12.26 as 12.26

I know you can use [value>x] type rules but I'm guessing you can't use formulae in those rules ?

View Replies!   View Related
Divide An Number Of Jobs Without Ending Up With Decimals
I'm trying to create a formula which will allow me to do the following

1. Enter the number of jobs received
2. Divide it by the staff available without ending up with decimals.

As an example. Say I have 60 jobs to be allocated and there are 13 peeps to distribute them to I'm currently getting 4.62. What I need to do is make sure that the jobs are only issued as whole numbers. E.g 5 peeps gets 4 and 8 get 5. I also need to factor in jobs on hand etc but I have already cracked this.

View Replies!   View Related
Formula To Increase A Number By 10%?
formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.

View Replies!   View Related
Increase Reference Number
in cell A1 I have a ref no. eg aa/01/bb
in cell A2 I have a ref no. eg aa/02/bb

only the middle number increases in the reference each time eg: /01/

is there a formula that can achieve this or am i doomed to manual input, I have made a few attempts but cannot work it out.

View Replies!   View Related
Macro To Increase A Number
what i need is a macro to run when I print a form. I am making a job card with a unique number on it ie: 100. when I print the form, I then need the 100 to change to 101 and so on. I cant work this one out.

EDIT - Ive attached my work in progress. It is for a computer repair shop. I have a few macros in there as I need to email a copy of the workbook too.

when you open the workbook, you will see the job number in red. I just need a macro tht will increase that number +1 every time it runs. I also need the email macro to rename the workbook to the customer name input in cell B4 - but I think im best to post this request in a new thread?

View Replies!   View Related
Macro: Increase Row Number Each Month
I am trying to write a program that needs to select a different cell everytime it is ran. For example, this month when it runs I need it to select cell BL137. Next time it is ran it will need to select cell BL138. Month after BL139. The cell it selects will always be in the same column (column BL) and the cell number always increases by the same amount (1).

View Replies!   View Related
Increase The Receipt Invoice Number By 1
I created an receipt template in excel. How can I have it increase the receipt invoice number by 1 every time I open this template? For example the first receipt is 100, I want the second receipt to be 101, and so on.

View Replies!   View Related
Increase Number In Same Cell Across Multiple Worksheets
I have multiple worksheets (too many, actually!) and each worksheet is a record. I need to enter a Record Number into B5 of each sheet. The Record Number doesn't start at 1. I'd like to enter a number into the first sheet and the rest of the sheets to increase by 1. However, I only need to do this to some sheets.

View Replies!   View Related
Increase Aphanumeric Number For Each Change In Data
I have many data in a worksheet named "Table" with "Item" in column A and "Reference" in column B. For each change of item, I need to assign a reference number with a prefix. Below is a sample of the data.

Column A Column B
Item Reference
Orange R9
Orange R9
Orange R9
Apple R10
Apple R10
Apple R10
Mango R11
Mango R11

The starting reference number is not fixed. It could start from 8 or 10.

Thought it would be possible to automate this process using vba.

View Replies!   View Related
IF Function Formula Logic: For Every Increase Of Of Mhz, Give 25.00 Per 100 Increase
I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.

View Replies!   View Related
Convert Degrees Minutes & Decimals Of A Minute (12 34.567') To Degrees And Decimals Of A Degree (12.57611)
I am trying to convert Degrees Minutes & Decimals of a minute (12 34.567') to Degrees and decimals of a degree (12.57611). I have the formula to convert latitude, that is two digits, but it doesn't want to work with longitudes, three digits. (see attachment). This is the formula that I am using:

=IF(A2="","",(INT((LEFT(A2,3)+MID(A2,4,6)/60)*100000)/100000)&"d")

View Replies!   View Related
How Increase Sheets Number+1 For All Sheets With Vba?
How increase Sheets number+1 for all Sheets with Vba?

View Replies!   View Related
Decrease Cell Value
Is there a formula or maybe some VB code that can be used to decrease a cell value if another cell's value is changed. e.g. I have a userform that has a Textbox that will put a 6 digit number in cell J4 & a Combobox that enters a number in cell E4. If the value of J4 is changed from the Textbox, I would like to have cell E4's value decrease by 1. If J4 doesn't change, cell E4 remains unchanged.

View Replies!   View Related
Decrease Time From Splash Screens
In this sheet are 2 Splash screens which randomly open on startup. This is the code for them:

View Replies!   View Related
Automatically Increment/Decrease Cell Value By One
I have a single cell in a spreadsheet which I'm trying to increment by 1 on demand.

My ideal would be a button which increments by 1, and another button which decreases the value by 1.

Is there any simple way to do this?

View Replies!   View Related
Increasing/decreasing; Rate Of Decrease - Spreadsheet
Im trying to make this:

Amount of money: 1000 (changeable)
Beginning # of units: 0,1 (changeable)
Delta: 200 (changeable)
Rate of decrease: 50% (changeable)

0,1 unit should be added for every 200$ increase (1000+200=1200; 1200+200=1400; 1400+500=1900; 1900+256=2156 etc)
0,1 unit should be taken away after decreasing by100$ (because the rate of decrease = 50% (changeable))

After increasing of 1000 + 200, quantity of units should also increase for 0,1, so it should be 0,2 (1200), 0,3(1400), 0,4(1600).. Amount of money can increase not only by 200, but for any sum. If that sum is (for example) 500, we should increase by 0,2 etc.

But when this some decreasing we are using rate of decrease (for example 50%, (changeable):
0,4 units 1600
0,3 units 1500
0,2 units 1400
0,1 unit 1300

View Replies!   View Related
Formula To Decrease A Margin, In Connection With Increasing Basic Value
I'm trying to build a formula to form a price-list. I have some basic prices from a supplier and want to build my prices with a simple rule: the higher the basic price is (column A), the lower my profit margin (in %) should be (column B). Example:

Basic value is $50, my price is $75 (50% margin)
Basic value is $100, my price is $130 (30% margin)
Basic value is $150, my price is $172,5 (15% margin)
And so on...

I forgot most of what I've learned on Excel at my university (long time ago...), so I tried to do it by using simple thresholds, with "if" function:

View Replies!   View Related
Font Size Decrease In Data Validation List
Using excel 2007, I have a worksheet with numerous data validation drop down lists. I was making a few changes to the worksheet and then I restarted the code. The font size of all my drop down lists displayed as a smaller font (maybe 2 sizes smaller) than had been displayed before. I went back to a previously saved copy of the code and the font size in the drop downs is back at the original size. Did I do something to cause this or is it excel 2007?

View Replies!   View Related
VBA (Keyboard Strokes)
I've programmed in many different forms of BASIC in my days, but I'm having too much trouble with VBA, and can't figure out if it's me or if it's the version of Excel I'm using (2002). I wrote a program in Excel, where if certain cells contain values other cell's calculations will become active. I want to click on a button that I created on the spreadsheet, then be able to select different keyboard strokes to activate these cells. I understand that there are 3 event codes that circle around this concept and that is KeyDown, KeyUp and KeyPress. Whenever I type in what MS Help told me to type in for these events, it always returns a runtime error.

View Replies!   View Related
Keyboard Disable
Does anyone know if there is anyway that we can command Excel to avoid accepting aNY KEYBOARD ENTRIES? what intend to do is restrict a certain region on a worksheet for Users not to be able to type anything but but there are commandbuttons on the header which use: Range("C65536").End(xlUp)(2, 1) = "Value for the last cell" code to get the input into the cell. The purpose is to make use of the cmdbuttons with mouse but the data notto be keyed in !!!

View Replies!   View Related
Flushing The Keyboard Buffer
I've run into a problem and I cannot resolve. I am designing an Excel Application in VBA. During the execution of the VBA code, the user will press different keys on the keyboard. These keystrokes are determined by using the GetAsyncKeyState Function. The problem happens when I exit from the VBA code and move back to a worksheet outside the code execution.

Lets say a user has pressed the 'Q' and 'X' key just prior to the final VBA subroutine running and releasing the worksheets back to the user. On the worksheet, in the selected cell will appear the 'Q' and 'X'. For some reason these keystrokes are not 'flushed' from the keyboard buffer prior to the code completion and are being transfered to the active worksheet. This is really annoying if I am testing the code in the VBA editor, because the spurious keystrokes will be placed in my VBA code, causing me to search for the out of place characters.

View Replies!   View Related
Enable The CONTROL From My Keyboard
My ENTER button in my keyboard does not work.

I think it is because I have disable it.

does anybody know hot to enableit?

kind of:

Application.OnKey "^"

but don't know which one!

View Replies!   View Related
Activate Userform Check Box With Keyboard
I would like to be able to check a checkbox on a userform with a keyboard stroke rather than using the mouse. Any key will do, "P" or Enter would be prefered. It would make data entry much easier.

View Replies!   View Related
Right Click Mouse Button On The Keyboard
For instance if I want to cut a row and column, how do I insert with the keyboard without pasting over other data

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved