How to display a cell value as a text entry in another cell?

[StargateFanNotAtHome]

What does one call this? I can't find anything because I don't know
how to describe what I'm trying to do <g>.

In a financial spreadsheet I'm overhauling, I found something that can
be finetuned to make life less difficult. Currently in a cell, cell
E23, they have this text description for 'mileage':

@ 0.45/km

Yet they have a cell for the English display of that information that
a subsequent formula in I23 draws its information from, cell E62,
which shows as $0.45, and is out of the print area. That's the cell
you upate for the formulas to be current.

Rather than having to edit the sheet several times when the rate
changes and since we have to change the "master" cell info at E62,
anyway, how could we do something like this instead for E23:

instead of manually typing in value
in description: @ 0.45/km
have it pick it up from E62: @ [rate as per cell E62,
with custom currency format]/km

How would we do this, though?

Thank you!! D

 

[Pete_UK]

I used this as the custom format string:

"@ "0.00"/km"

Seems to do what you wanted.

Hope this helps.

Pete

 

[StargateFan]

I used this as the custom format string:

"@ "0.00"/km"

Hi, thanks. Only one challenge, it's not picking up the value of E62,
the 0.45 which stands for $0.45 per km? Was hoping to have to change
only one field and for results to be reflected in the 'mileage' fields
in both languages. To do something manually, I can do that, no
problem. But it's how to get the 0.45 of E62 as

@ $0.45/km in text description found in cell for the English and
@ 0.45 $/km in the French cell, hence needing a way to have one cell's
value show up as properly custom formatted text in two other cells.

Cheers!

Seems to do what you wanted.

Hope this helps.

Pete

What does one call this?  I can't find anything because I don't know
how to describe what I'm trying to do <g>.

In a financial spreadsheet I'm overhauling, I found something that can
be finetuned to make life less difficult.  Currently in a cell, cell
E23, they have this text description for 'mileage':

@ 0.45/km

Yet they have a cell for the English display of that information that
a subsequent formula in I23 draws its information from, cell E62,
which shows as $0.45, and is out of the print area.  That's the cell
you upate for the formulas to be current.

Rather than having to edit the sheet several times when the rate
changes and since we have to change the "master" cell info at E62,
anyway, how could we do something like this instead for E23:

instead of manually typing in value
 in description:                               @ 0.45/km
have it pick it up from E62:              @ [rate as per cell E62,
with custom currency format]/km

How would we do this, though?

Thank you!!  D

 

[Pete_UK]

In the cell(s) that is/are custom-formatted, you need to have the
formula:

=E62

to get the value from that cell, displayed how you have set it up.

Hope this helps.

Pete

I used this as the custom format string:

"@ "0.00"/km"

Hi, thanks.  Only one challenge, it's not picking up the value of E62,
the 0.45 which stands for $0.45 per km?  Was hoping to have to change
only one field and for results to be reflected in the 'mileage' fields
in both languages.  To do something manually, I can do that, no
problem.  But it's how to get the 0.45 of E62 as

@ $0.45/km in text description found in cell for the English and
@ 0.45 $/km in the French cell, hence needing a way to have one cell's
value show up as properly custom formatted text in two other cells.

Cheers!

Seems to do what you wanted.

Hope this helps.

Pete

What does one call this?  I can't find anything because I don't know
how to describe what I'm trying to do <g>.
In a financial spreadsheet I'm overhauling, I found something that can
be finetuned to make life less difficult.  Currently in a cell, cell
E23, they have this text description for 'mileage':
@ 0.45/km
Yet they have a cell for the English display of that information that
a subsequent formula in I23 draws its information from, cell E62,
which shows as $0.45, and is out of the print area.  That's the cell
you upate for the formulas to be current.
Rather than having to edit the sheet several times when the rate
changes and since we have to change the "master" cell info at E62,
anyway, how could we do something like this instead for E23:
instead of manually typing in value
 in description:                              @ 0.45/km
have it pick it up from E62:              @ [rate as percell E62,
with custom currency format]/km
How would we do this, though?
Thank you!!  D- Hide quoted text -

- Show quoted text -

 

[Arjun]

You know your way around excel so I will give you my own example for a solution.

In cell a16 you have 0.45

Then in a18 you enter
="@ " & A16 & "/km"
this should get you @ 0.45/km in the cell a18
similarly for the French connection.
Hope this is ok
Arjun