Format issues in the data table of a chart

Karenola

New Member
Joined
Oct 10, 2006
Messages
1
I have a chart (showing the data table) that is linked to another spreadsheet. When that linked spreadsheet is open, the numbers in the data table show as percents, which is what I want. But when that linked spreadsheet is closed, the numbers in the data table become decimals, losing the percentage format. Do you know why that happens and how I can fix it? Thank you
Whoops. I meant to add that I have posted this at Experts-Exchange. I got one reply but it is not what I need.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,113,792
Messages
5,544,311
Members
410,602
Latest member
lidovi
Top