Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a "+" for a cell reference (+C28)
Will someone please be able to clarify,
What is the use of adding a + in front of a cell reference (ex: +C28) Using Excel 2003? Thanking you mariyah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a "+" for a cell reference (+C28)
Mariyah,
I'm not certain, but I think that is something for a different spreadsheet application or an older one. Maybe Lotus or older XL. I think some of the old-timers are just used to it. I see my boss doing that. I don't think it does anything in XL. It might be similar to starting a formula with an equals sign. HTH, Conan "Mariyah Merchant" <Mariyah wrote in message ... Will someone please be able to clarify, What is the use of adding a + in front of a cell reference (ex: +C28) Using Excel 2003? Thanking you mariyah |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a "+" for a cell reference (+C28)
Nothing at all.
Some former Lotus users still do this. -- Kind regards, Niek Otten Microsoft MVP - Excel "Mariyah Merchant" <Mariyah wrote in message ... | Will someone please be able to clarify, | What is the use of adding a + in front of a cell reference (ex: +C28) Using | Excel 2003? | | Thanking you | mariyah |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding a "+" for a cell reference (+C28)
The + comes from Lotus. It makes no difference whether you use it or not in
Excel 2003 (you probably shouldn't use it; just cleaner). Regards, Ryan--- -- RyGuy "Niek Otten" wrote: Nothing at all. Some former Lotus users still do this. -- Kind regards, Niek Otten Microsoft MVP - Excel "Mariyah Merchant" <Mariyah wrote in message ... | Will someone please be able to clarify, | What is the use of adding a + in front of a cell reference (ex: +C28) Using | Excel 2003? | | Thanking you | mariyah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas using "+" cell reference causes r1c1 in linked sh | Excel Discussion (Misc queries) | |||
Adding hh:mm times in a row as part of a "named" cell | Excel Worksheet Functions | |||
Problem with adding "+1" to one cell while another cell decreased by "1"? | New Users to Excel | |||
How do I reference a cell as PART of a vlookup "Table_Array" locat | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |