Excel question about %

parc · 2015-08-10 15:00:34

Hi there I had to paste a % from one sheet to the other. It's in percentage format (ie 25%) but I need to get it to just read 25. The problem is if I make it 'general' or a 'number' then it reads 0.25143 How do I get it to just read 25 Thanks in advance!

10-08-2015 03:00PM

#1

parc

Registered Users, Registered Users 2 Posts: 797 ✭✭✭

Join Date: January 2011

Posts: 625

Hi there

I had to paste a % from one sheet to the other. It's in percentage format (ie 25%) but I need to get it to just read 25.

The problem is if I make it 'general' or a 'number' then it reads 0.25143

How do I get it to just read 25

Thanks in advance!

0

Comments

#2 10-08-2015 03:02PM

Pullover

Registered Users, Registered Users 2 Posts: 24 ✭

Join Date: November 2014

Posts: 14

Format the cell, change it to number or general and change the number of decimal places to zero.

0
#3 10-08-2015 03:08PM

hardCopy

Registered Users, Registered Users 2 Posts: 5,969 ✭✭✭

Join Date: December 2003

Posts: 5876

The right function can be used to give you the two right most digits i.e. '25'

Where A1 = 0.25, use
RIGHT(A1,2)

EDIT: Forget that, you may as well just multiply by 100

0
#4 10-08-2015 06:00PM

homer911

Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭

Join Date: September 2007

Posts: 4684

Fill the target cells with 100 and then Copy > Paste Special > Multiply

0