#### lipin

##### New Member
I have numerous cells on a summary sheet linked to corresp. cells on other worksheets where the data is entered. Let's say the user enters \$196,500.
I have an intermediate sheet that is linked to hundreds of accounts and their amounts.
Ex.
supplies 196,500
so on this intermediate sheet I format the columns so
supplies 196.5

But when I Link the cells on the summary sheets to this intermediate it is showing up as
supplies 196,500
But On the sumamry sheets I need it to come in as 196.5 so calcualtions can be done with it. I know how to paste a format, tried it. Not very efficient because sheets so complex and lengthy.

Is there a way to get the keep the changed format through the Link?? I thought changing it all on the intermediate sheet and then linking to that would work, but it isn't.
Hope I was clear enough. Thanks.

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

You would need a macro to do this

steve w

What messgae is appearing when you try do do this application?

If you want you can send me your spreadsheet and i will sort it out for you.

gareth, no message appears. The sheets all open without error.

There are 3 sheets all linked together like this:
cell A1 of original input sheet contains:
\$196,500

cell A1 of middle sheet = cell A1 of original sheet
but here I changed format so it reads:
196.5

cell A1 of third summary sheet = cell A1 of middle sheet and so I was expecting 196.5 but it comes up as \$196,500

On the summary sheet performs numerous calculations and needs cell A1 to be 196.5
not 196,500.

You may ask why not just change format on the 3rd sheet. I tried but calculations still operate as 196,500 is the figure although it looks to the user as 196.5

So I need the figures to actually change from 196,500 to 196.5

Since there are multiple input sheets with hundreds of accounts I made the middle sheet of two columns: account # and amount
and because there are multiple summary sheets all tied together that give diff. results.

Can someone remedy this for me?

OK So instead of Excel doing it I changed 196,500 to 1,96.5 by doing:

B1 = fixed(A1/1000,1) which works find and when I link the summary page cell to B1 it works fine in most the calculations except one. There are some autosums already built in to the summary sheets. But they won't work. The numbers are showing in the cells but then the autosums won't add anything, they will add it if I just type in the numbers but not the linked cells. What's up?
If I do A1+A2+A3+A4+A5+A6 it will add though. But there are so many sums throught the sumamry pages.
Anyone know how to fix this? Thanks.

Replies
1
Views
170
Replies
2
Views
115
Replies
0
Views
175
Replies
1
Views
260
Replies
0
Views
441

1,196,487
Messages
6,015,493
Members
441,898
Latest member
kofafa

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

### Which adblocker are you using?

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

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