Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 419
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formulas using "+" cell reference causes r1c1 in linked sh Andy D Excel Discussion (Misc queries) 4 October 25th 07 05:11 PM
Adding hh:mm times in a row as part of a "named" cell Joe Excel Worksheet Functions 2 August 20th 07 02:15 PM
Problem with adding "+1" to one cell while another cell decreased by "1"? Michael Slater New Users to Excel 12 July 28th 07 01:06 AM
How do I reference a cell as PART of a vlookup "Table_Array" locat -Rocket Excel Worksheet Functions 2 January 4th 07 03:49 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"