#### redspanna

##### Well-known Member

- Joined
- Jul 27, 2005

- Messages
- 1,462

- Office Version
- 2016

- Platform
- Windows

In cell AG9 I have a simple formula to work out a percentage value from two numbers in other cells.

so cell AG9 holds the formula

**=K14/500**and then cell AG9 if formatted as a PERCENTAGE, the result showing (with no decimal points) as

**10**

is there a formula to then show this result as a general number and not a percentage in another cell

so in cell AG10 the number

**10**will be displayed and formatted as GENERAL

hope this make sense and thanks in advance