cell A1 to appear the same as designated cell in other sheet

[famieshafie]

As what it says in the subject.

I tried writing this in sheet1 A1:

=text('sheet2'!E24, "@")

It appears the value as in E24 but i cannot format cell the value to accounting and put the demical value to 2.

it still appears like this:

2345.54332

Is there anything other than TEXT function

 

[Stormseed]

Assuming that the above number formatted as Text is in cell A1, try this:

in cell B1, enter the formula: =A1+0, then select cell B1 --> Press Ctrl+1 --> select format as Number and select 2 in "Decimal places", finally click on OK.

 

[joy_666]

Hi,
You could also u the formula as =text('sheet2'!E24, "0.00")

The above rounds and restricts the value to 2 decimal places....

If you want 4 decimals then use "0.0000"

 

[famieshafie]

Hi,
You could also u the formula as =text('sheet2'!E24, "0.00")

The above rounds and restricts the value to 2 decimal places....

If you want 4 decimals then use "0.0000"

Genius. Isn't that easy.

 

[joy_666]

 

[famieshafie]

Hi,
You could also u the formula as =text('sheet2'!E24, "0.00")

The above rounds and restricts the value to 2 decimal places....

If you want 4 decimals then use "0.0000"

I also tried this and it works.

 

[Stormseed]

What did you try in the first place ? Which solution from the above two solutions ?

 

[famieshafie]

Assuming that the above number formatted as Text is in cell A1, try this:

in cell B1, enter the formula: =A1+0, then select cell B1 --> Press Ctrl+1 --> select format as Number and select 2 in "Decimal places", finally click on OK.

also tried this and it works. tq

 

[famieshafie]

Both works fine. I tried Joy's because I couldn't understand what storm was saying... but then quickly understood what to do I tried storm's and it works fine.

 

[Stormseed]

Ok, glad that it worked for you.
You may use a solution which suits your needs and with which you are comfortable