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

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,534
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
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Twollaston

Board Regular
Joined
May 24, 2019
Messages
233
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 %?
 

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,534
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
 

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,534
Managed to resolve this. amended code in my macro which was coping the data to he various sheets
 

Watch MrExcel Video

Forum statistics

Threads
1,099,302
Messages
5,467,822
Members
406,557
Latest member
Anune153

This Week's Hot Topics

Top