$
 

What does the dollar sign do in excel?
--
Brian

$
 

One usage is an absolute reference. The formula =A! when copied to a
different cell may change to =B1 or =A2. The formula =$A$1 will not change
when copied.
--
Gary's Student


"brianwakin" wrote:

What does the dollar sign do in excel?
--
Brian

$
 

What about when a $ sign is used after a function name such as LEFT$?



"Gary's Student" wrote:

One usage is an absolute reference. The formula =A! when copied to a
different cell may change to =B1 or =A2. The formula =$A$1 will not change
when copied.
--
Gary's Student


"brianwakin" wrote:

What does the dollar sign do in excel?
--
Brian

$
 

crazybass2 wrote:
What about when a $ sign is used after a function name such as LEFT$?



You avoid converting the string to a Variant. See

http://www.dicks-blog.com/archives/2...on-efficiency/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com