![]() |
|
#51
|
||||
|
||||
![]() Here's an article with some doubleclick shortcuts. I'd rather use the keyboard for some of these but it's nice to know they are there too:
http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/
__________________
Exam FM Formula Summary (covers theory of interest formulas from the pre-2007 FM exam). |
#52
|
||||
|
||||
![]() Quote:
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial. My latest favorite quotes, updated Apr 5, 2018. Spoiler: |
#53
|
||||
|
||||
![]() found this by accident a while back.
entered ---> displayed 6**6 ---> 6,000,000(depending on format) used to use 6e6 ---> 6,000,000(depending on format) but like using the numpad keys |
#54
|
||||
|
||||
![]() does anyone know if there exists a shortcut for adding/removing decimal places (formatting)?
|
#55
|
||||
|
||||
![]() One of the default toolbars has a couple of icons, one that has a little arrow and .0 on the top line and .00 on the bottom. The other has the positions reversed and the arrow points the other way. These let you increase or decrease the number of decimals displayed in the currently select cell(s).
__________________
Carol Marler, "Just My Opinion" Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial. My latest favorite quotes, updated Apr 5, 2018. Spoiler: |
#56
|
||||
|
||||
![]() Thanks JMO, I knew about the toolbar, I meant keyboard shortcuts....
|
#57
|
||||
|
||||
![]() I don't think it exists. I tried writing a macro for it awhile ago but that seems to be impossible too. It's about the only thing I ever use the mouse for when I am using excel anymore.
__________________
ADoubleDot: I'm an actuarial icon. **** Juan. |
#58
|
||||
|
||||
![]() If you could live with lame limited usability (unless you found the complete rules of format specifications - I haven't looked for it), you could build your own decimal increaser/decreaser with something roughly starting with
Code:
Sub macIncrDec() If InStr(Selection.NumberFormat, ".") = 0 Then Selection.NumberFormat = Selection.NumberFormat & "." Selection.NumberFormat = Selection.NumberFormat & "0" End Sub My definition of lame might be something that's only usable 98% of the time or crashes over 0% of the time. But you might get 98% satisfaction with an expansion of something like the above, or 100% depending on how you use Excel. |
#59
|
||||
|
||||
![]() It seems to never work for me. Even after I add the "end if" in the place where I assume you meant it to be. Thanks for the effort though.
__________________
ADoubleDot: I'm an actuarial icon. **** Juan. |
#60
|
||||
|
||||
![]() Try
Code:
Sub macIncrDec() If Selection.NumberFormat = "General" Then Selection.NumberFormat = "0." Else If InStr(Selection.NumberFormat, ".") = 0 Then Selection.NumberFormat = Selection.NumberFormat & "." End If End If Selection.NumberFormat = Selection.NumberFormat & "0" End Sub edit:All with Selection ![]() |
![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|