Why? Do you need to be able to go to a tab based on the contents of a cell?

Please clarify the context as I have a couple of ideas

"Brisbane Rob" wrote:


I need to label tabs with numbers (123, 345, 874, etc) but I need them
formatted for lookup purposes as text i.e. in a cell I'd enter '123,
'345, '874, etc.

Is this possible?

Thanks for any ideas.


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=505267