Home |
Search |
Today's Posts |
#1
|
|||
|
|||
understanding dash dash in a excel formula
I have come across a function I do not understand.
1. Input Thursday, October 27, 2005 8:59:09 AM Formula =(--RIGHT(B2,LEN(B2) - (FIND(",",B2)+1))) Result (this is the result I wanted) 10/27/05 8:59 AM 2. Input Thursday, October 27, 2005 8:59:09 AM Formula =(RIGHT(B3,LEN(B3) - (FIND(",",B3)+1))) Result ( this is not the result i wanted) October 27, 2005 8:59:09 AM Why does putting "--" before "RIGHT" give me the desired result? |
#2
|
|||
|
|||
understanding dash dash in a excel formula
See http://www.xldynamic.com/source/xld....CT.html#format
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "ldebner" wrote in message ... I have come across a function I do not understand. 1. Input Thursday, October 27, 2005 8:59:09 AM Formula =(--RIGHT(B2,LEN(B2) - (FIND(",",B2)+1))) Result (this is the result I wanted) 10/27/05 8:59 AM 2. Input Thursday, October 27, 2005 8:59:09 AM Formula =(RIGHT(B3,LEN(B3) - (FIND(",",B3)+1))) Result ( this is not the result i wanted) October 27, 2005 8:59:09 AM Why does putting "--" before "RIGHT" give me the desired result? |
#3
|
|||
|
|||
understanding dash dash in a excel formula
The double dash is just a way to convert string to number. The differences
you see may be just formatting. the value should be: 38652.3744097222 to account for the 9 seconds. -- Gary''s Student "ldebner" wrote: I have come across a function I do not understand. 1. Input Thursday, October 27, 2005 8:59:09 AM Formula =(--RIGHT(B2,LEN(B2) - (FIND(",",B2)+1))) Result (this is the result I wanted) 10/27/05 8:59 AM 2. Input Thursday, October 27, 2005 8:59:09 AM Formula =(RIGHT(B3,LEN(B3) - (FIND(",",B3)+1))) Result ( this is not the result i wanted) October 27, 2005 8:59:09 AM Why does putting "--" before "RIGHT" give me the desired result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |