Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sadinga
 
Posts: n/a
Default international absulute cell reference

To make an absulute cell reference you use the dollar sign. How would you
make an absulute cell reference on a keyboard with no dollar sign? Example:
russian keyboard, japanese keyboard, ect...
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
AFAIK it is always the $ sign in all language versions (not sure though
about Japanese versions). Maybe ask this is the Japanese Excel newsgroup

--
Regards
Frank Kabel
Frankfurt, Germany

Sadinga wrote:
To make an absulute cell reference you use the dollar sign. How
would you make an absulute cell reference on a keyboard with no
dollar sign? Example: russian keyboard, japanese keyboard, ect...



  #3   Report Post  
RagDyer
 
Posts: n/a
Default

Is this a rhetorical question?
What happens when you click in the formula bar and hit <F4?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Frank Kabel" wrote in message
...
Hi
AFAIK it is always the $ sign in all language versions (not sure though
about Japanese versions). Maybe ask this is the Japanese Excel newsgroup

--
Regards
Frank Kabel
Frankfurt, Germany

Sadinga wrote:
To make an absulute cell reference you use the dollar sign. How
would you make an absulute cell reference on a keyboard with no
dollar sign? Example: russian keyboard, japanese keyboard, ect...



  #4   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi RD
never thought about this simple solution :-))

--
Regards
Frank Kabel
Frankfurt, Germany

RagDyer wrote:
Is this a rhetorical question?
What happens when you click in the formula bar and hit <F4?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Frank Kabel" wrote in message
...
Hi
AFAIK it is always the $ sign in all language versions (not sure
though about Japanese versions). Maybe ask this is the Japanese Excel
newsgroup


Sadinga wrote:
To make an absulute cell reference you use the dollar sign. How
would you make an absulute cell reference on a keyboard with no
dollar sign? Example: russian keyboard, japanese keyboard, ect...



  #5   Report Post  
RagDyer
 
Posts: n/a
Default

It might be a solution Frank, but I *really* would like to know what
*displays* in the Russian and Japanese versions.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Frank Kabel" wrote in message
...
Hi RD
never thought about this simple solution :-))

--
Regards
Frank Kabel
Frankfurt, Germany

RagDyer wrote:
Is this a rhetorical question?
What happens when you click in the formula bar and hit <F4?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Frank Kabel" wrote in message
...
Hi
AFAIK it is always the $ sign in all language versions (not sure
though about Japanese versions). Maybe ask this is the Japanese Excel
newsgroup


Sadinga wrote:
To make an absulute cell reference you use the dollar sign. How
would you make an absulute cell reference on a keyboard with no
dollar sign? Example: russian keyboard, japanese keyboard, ect...





  #6   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi RD
indeed also curious. though I've hear a Russian and Japanese version on my
MSDN DVD I won't risk installing it :-)

--
Regards
Frank Kabel
Frankfurt, Germany

RagDyer wrote:
It might be a solution Frank, but I *really* would like to know what
*displays* in the Russian and Japanese versions.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Frank Kabel" wrote in message
...
Hi RD
never thought about this simple solution :-))


RagDyer wrote:
Is this a rhetorical question?
What happens when you click in the formula bar and hit <F4?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Frank Kabel" wrote in message
...
Hi
AFAIK it is always the $ sign in all language versions (not sure
though about Japanese versions). Maybe ask this is the Japanese Excel
newsgroup


Sadinga wrote:
To make an absulute cell reference you use the dollar sign. How
would you make an absulute cell reference on a keyboard with no
dollar sign? Example: russian keyboard, japanese keyboard, ect...



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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
cell reference in a formula is called ??????????? Excel Discussion (Misc queries) 2 April 22nd 23 09:02 AM
how to cell reference a Chart title Rasoul Khoshravan Azar Charts and Charting in Excel 2 January 1st 05 05:00 PM
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS TD Excel Discussion (Misc queries) 1 December 14th 04 03:16 PM
Using a formula in a Hyperlink Cell reference sslabbe Excel Discussion (Misc queries) 4 December 10th 04 12:30 AM


All times are GMT +1. The time now is 11:06 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"