Hi,

If the OP only intends to show this then your fractional format seems
to be easiest solution.

Another approach if he wants to use nominator and denominator later on:
Insert my UDF NRN() from
http://www.sulprobil.com/html/neares...al_number.html
Select cells A1 and B1 together. Enter =NRN(PI(),999) as array formula
(with CTRL + SHIFT + ENTER).

Regards,
Bernd