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

famieshafie

New Member
Joined
Dec 25, 2008
Messages
18
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274
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

Board Regular
Joined
Dec 10, 2008
Messages
121
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"
 

Stormseed

Banned
Joined
Sep 18, 2006
Messages
3,274

ADVERTISEMENT

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

famieshafie

New Member
Joined
Dec 25, 2008
Messages
18
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

New Member
Joined
Dec 25, 2008
Messages
18
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

Banned
Joined
Sep 18, 2006
Messages
3,274
Ok, glad that it worked for you.
You may use a solution which suits your needs and with which you are comfortable :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,517
Messages
5,602,115
Members
414,505
Latest member
quoctrungvu99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top