Remove percentage symbol without changing the display value

↔️ ↕️


are you worrying how to remove

percentage symbol in your data set

without changing the value then here is

the answer there is a table out here

which consists of values in percentage

you might have tried formatting the cell

but by doing so the percentage symbol

will be removed but the value also will

change now I am going to show you how to

remove the percentage symbol without

changing the value all you have to do is

Click somewhere and type 100

copy that cell and select the data sets

containing percentage symbol right click

over there and go to paste special and

click on paste special here click on

multiply and click OK that's it

percentage symbol has gone hope you got

the answer meet you in the next video


Related queries:

how to show percentage sign in excel
percentage symbol not showing in excel
how to show percentage in excel