Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plus sign in front of formulas
I am sick and tired of people using the plus key to begin entering formulas.
It looks nasty, I always feel compelled to fix it, so please stop doing it. NOW. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plus sign in front of formulas
ROFL!!! I hate that, too!!
******************* ~Anne Troy www.OfficeArticles.com "JM" wrote in message ... I am sick and tired of people using the plus key to begin entering formulas. It looks nasty, I always feel compelled to fix it, so please stop doing it. NOW. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plus sign in front of formulas
On Wed, 20 Jul 2005 13:47:45 -0500, "JM" wrote:
I am sick and tired of people using the plus key to begin entering formulas. It looks nasty, I always feel compelled to fix it, so please stop doing it. NOW. Just assign this macro to a button on your toolbar and stop complaining: Sub RemovePlus() Dim rng As Range For Each rng In Selection If Mid(rng.Formula, 2, 1) = "+" Then rng.Formula = Replace(rng.Formula, "+", "", 1, 1) End If Next End Sub Per Erik |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plus sign in front of formulas
Very nice, Erik!!
******************* ~Anne Troy www.OfficeArticles.com "Per Erik Midtrød" wrote in message ... On Wed, 20 Jul 2005 13:47:45 -0500, "JM" wrote: I am sick and tired of people using the plus key to begin entering formulas. It looks nasty, I always feel compelled to fix it, so please stop doing it. NOW. Just assign this macro to a button on your toolbar and stop complaining: Sub RemovePlus() Dim rng As Range For Each rng In Selection If Mid(rng.Formula, 2, 1) = "+" Then rng.Formula = Replace(rng.Formula, "+", "", 1, 1) End If Next End Sub Per Erik |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Plus sign in front of formulas
Might be easier to do
select a single cell, then do Edit=Goto =Special and select formulas then do Edit =Replace What =+ With = Not as precise as the code, but It would be unusual for this to cause a problem. Of course the above could be easily done in code. -- Regards "Anne Troy" wrote in message ... Very nice, Erik!! ******************* ~Anne Troy www.OfficeArticles.com "Per Erik Midtrød" wrote in message ... On Wed, 20 Jul 2005 13:47:45 -0500, "JM" wrote: I am sick and tired of people using the plus key to begin entering formulas. It looks nasty, I always feel compelled to fix it, so please stop doing it. NOW. Just assign this macro to a button on your toolbar and stop complaining: Sub RemovePlus() Dim rng As Range For Each rng In Selection If Mid(rng.Formula, 2, 1) = "+" Then rng.Formula = Replace(rng.Formula, "+", "", 1, 1) End If Next End Sub Per Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What does a plus sign in front of a cell reference mean? | New Users to Excel | |||
how do I copy text with a plus sign at the front? | Excel Discussion (Misc queries) | |||
How to display $ sign in front of: 50 under, 50 over | Excel Discussion (Misc queries) | |||
How do you make a plus sign appear in front of a number? | Excel Discussion (Misc queries) | |||
Plus sign in front of a formula | Excel Discussion (Misc queries) |