Stop % showing in outcome of formula

B

Beginner

Hi

I've got a formula that has returned an outcome in %, which is what I'm
after for that cell, but for my next formula linking to that cell I need the
formula to pick up the number not the percentage, ie its showing 50% but I
need it to pick up 50. Any help would be greatly appreciated
 
A

Arvi Laanemets

Hi

With first formula in A1
=A1*100
(50% is same as 0.5) and format as Number or General


Arvi Laanemets
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top