Percent (%) displaying on linked sheet on one PC but not on another

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,561
Office Version
  1. 2021
Platform
  1. Windows
I have a workbook, where I have several sheets that links to items on sheet 1

Sheet1 contains values as well as percentages


The values and percentages are displayed correctly on the linked sheets on My PC, but the percentages are displayed as values on the linked sheets when copied on to another PC



I have looked at regional settings as well as the advanced options but cannot find anything that will affect this



It would be appreciated if someone can advise on how this can be resolved
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
I have a workbook, where I have several sheets that links to items on sheet 1

Sheet1 contains values as well as percentages


The values and percentages are displayed correctly on the linked sheets on My PC, but the percentages are displayed as values on the linked sheets when copied on to another PC



I have looked at regional settings as well as the advanced options but cannot find anything that will affect this



It would be appreciated if someone can advise on how this can be resolved

Are you saying the value in the formula bar, or the value displaying in the cell? Because when you make formatting changes, it doesn't change the data, it just changes the display so the value on the back stays the same. Have tried updating the formatting on the new sheet to %?
 
Upvote 0
Thanks for the reply. It is the value displaying in the cell. The values are displayed correctly, but percentages in the cell are not shown as a percentage but as a value for eg 1
 
Upvote 0
Managed to resolve this. amended code in my macro which was coping the data to he various sheets
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

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
Back
Top