ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   international absulute cell reference (https://www.excelbanter.com/excel-discussion-misc-queries/2395-international-absulute-cell-reference.html)

Sadinga

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...

Frank Kabel

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...




RagDyer

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...




Frank Kabel

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...




RagDyer

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...




Frank Kabel

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...





All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com