<~----> EXCEL help - Page 2 - Hardware Canucks
Go Back   Hardware Canucks > SOFTWARE > O/S's, Drivers & General Software
Reload this Page EXCEL help
Mark Forums Read
Media Gallery Register Members List LAN Calendar Search Today's Posts

    
Reply
Page 2 of 2 < 1 2
 
LinkBack Thread Tools Display Modes
  #11 (permalink)  
Old February 3, 2010, 09:01 AM
CMetaphor's Avatar
Quadfather
  
Join Date: May 2007
Location: Montreal, Canada
Posts: 4,977

My System Specs

Default
Wouldn't brackets use the literal value of the the cell name instead of that cell's value?

Ex: Cell A01 has "5" as data.
A01 = 5
[A01] = A01

Maybe?
__________________
"Backed by common sense and physics!" -Squeetard
Reply With Quote
  #12 (permalink)  
Old February 3, 2010, 09:03 AM
MarkOne's Avatar
Banned
F@H
  
Join Date: Oct 2009
Location: Chertsey 60 KM north of Montreal
Posts: 4,015
Default
ok the SI is for the french formula... but on a personnel note , I will use the English one, unless you are at school and they ask you to learn the french one.
Reply With Quote
  #13 (permalink)  
Old February 3, 2010, 09:03 AM
Hall Of Fame
  
Join Date: Oct 2007
Posts: 1,429
Default
no, I think do to that you precede the value with a '

'A01

or wrap it in quotes.


and no probs!
Reply With Quote
  #14 (permalink)  
Old February 3, 2010, 09:56 AM
MarkOne's Avatar
Banned
F@H
  
Join Date: Oct 2009
Location: Chertsey 60 KM north of Montreal
Posts: 4,015
Default
I try the same formula as CM, I use the SI instead, no [] and my regional setting is set to , insted of . put it's excel 2003 french and it work.... will try with 2007 at home
Reply With Quote
  #15 (permalink)  
Old February 3, 2010, 10:25 AM
Top Prospect
  
Join Date: Apr 2009
Location: Montreal, Québec
Posts: 219
Default
Quote:
Originally Posted by MarkOne View Post
ok the SI is for the french formula... but on a personnel note , I will use the English one, unless you are at school and they ask you to learn the french one.
yeah if = si (in french).

Actually I don't speak english around very much here, not even in school (I am going to french school since I was a kid). I only speak english with you guys
Reply With Quote
  #16 (permalink)  
Old February 3, 2010, 10:55 AM
MarkOne's Avatar
Banned
F@H
  
Join Date: Oct 2009
Location: Chertsey 60 KM north of Montreal
Posts: 4,015
Default
Quote:
Originally Posted by LC0g View Post
yeah if = si (in french).

Actually I don't speak english around very much here, not even in school (I am going to french school since I was a kid). I only speak english with you guys
same situation here, all true In Rawdon I have few english customer. but for some reason they are not my main one . they are mainly Polish and Russian Irish immigrants , and they are not fund of computer. not blame here.

I born in Chicoutimi... so french all the way.
Reply With Quote
Reply
Page 2 of 2 < 1 2


« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Similar Threads
Thread Thread Starter Forum Replies Last Post
excel - timetable for work CTA O/S's, Drivers & General Software 0 March 26, 2009 01:04 PM