N Nick Hodge Oct 10, 2006 #2 Rasoul If you just want to show this temporarily then Ctrl+` (On a UK keyboard). It's the key above Tab. If you want it permanently, say to print, etc, prefix the formula with a single apostrophe ' It will not show but the formula will -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) www.nickhodge.co.uk
Rasoul If you just want to show this temporarily then Ctrl+` (On a UK keyboard). It's the key above Tab. If you want it permanently, say to print, etc, prefix the formula with a single apostrophe ' It will not show but the formula will -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England (e-mail address removed) www.nickhodge.co.uk
