percentage question

[bionicle]

hi all,

just wondering if there is a formula that allows me to show a percentage in the following format within a cell.

10/50

thanks Steve

 

[steve the fish]

You can format the cell as fraction. Then use type as hundredths.

 

[Scott T]

You can format the cell using one of the options under Fraction in the Category list or a custom format.

 

[steve the fish]

Or if you always want 50 use custom format:

??/50

 

[bionicle]

Cheers all, didn't think of that