Hi Roelof:

With 'show formulas' switched on the alignment is not actived, probably
because it is merely a check mode rather than a normal display mode.

Therefore, as far as I know, it is not possible.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"rfdh" wrote:

In Excel, how do I justify cell values and formulas to the right hand side of
cell after selecting "show formulas"

The headings are OK, but the values and formula displays keep going to the
left of the cells.

Roelof