Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What do these characters mean?
Hi
the dollar signs indicate an absolute reference. See: http://www.cpearson.com/excel/relative.htm -- Regards Frank Kabel Frankfurt, Germany simsjr wrote: Ok, I get the following cell formula when I paste a link to a cell in another tab. It looks like this: ='Example Tab'!$L$8 What I'd like to know is what the exclamation point and dollar signs mean. Why can't Excel just do something like this instead? ='Example Tab'L8 Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
Different Characters | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions |