Hi,
I want to remove the percentage of values for cells D4 to G4. The values are referred from other sheets. Lets say I wanted D4 to be only 86, not 86%.
I want to remove the percentage of values for cells D4 to G4. The values are referred from other sheets. Lets say I wanted D4 to be only 86, not 86%.
| Team Performance-2021.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 3 | Month | Jan-2021 | Feb-2021 | Mar-2021 | Apr-2021 | May-2021 | Jun-2021 | ||
| 4 | % Quotation on Time | 86% | 77% | 75% | 69% | ||||
| 5 | No. Quotations | 57 | 64 | 91 | 39 | ||||
Sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D4 | D4 | ='[Quotations score card 2021.xlsx]Mar-2021'!$I$14 |
| E4 | E4 | ='[Quotations score card 2021.xlsx]Apr-2021'!$I$14 |
| F4 | F4 | ='[Quotations score card 2021.xlsx]May-2021'!$I$14 |
| G4 | G4 | ='[Quotations score card 2021.xlsx]June-2021'!$I$14 |
| D5 | D5 | ='[Quotations score card 2021.xlsx]Mar-2021'!$D$14 |
| E5 | E5 | ='[Quotations score card 2021.xlsx]Apr-2021'!$D$14 |
| F5 | F5 | ='[Quotations score card 2021.xlsx]May-2021'!$D$14 |
| G5 | G5 | ='[Quotations score card 2021.xlsx]June-2021'!$D$14 |
