software

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: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=505267Why? 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

quot;Brisbane Robquot; wrote:

gt;
gt; I need to label tabs with numbers (123, 345, 874, etc) but I need them
gt; formatted for lookup purposes as text i.e. in a cell I'd enter '123,
gt; '345, '874, etc.
gt;
gt; Is this possible?
gt;
gt; Thanks for any ideas.
gt;
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=505267
gt;
gt;

Hi Rob,
The tabs are text, there is no getting around that so there is
no problem using them as text in a lookup. Perhaps if you
give a bit of code where you have a problem we could help you
better. In other words you can usually try something faster
than asking a question and waiting for an answer. In any case
converting to numbers or to next shouldn't be a big deal. (Though
importing a CSV file appears to be an exception.)

obtain worksheet name
=MID(CELL(quot;filenamequot;,A1),FIND(quot;]quot;,CELL(quot;filenamequot;,A1)) 1,255)
or in VBA
SheetName = Application.Caller.Parent.Name

see quot; Examples of assigning a sheetnamequot; on my
www.mvps.org/dmcritchie/excel/sheets.htm

Your question is being answered in a newsgroup. Having to filter out
such sites as you are using makes web searches a more difficult.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Brisbane Robquot; gt; wrote in message
...
gt;
gt; I need to label tabs with numbers (123, 345, 874, etc) but I need them
gt; formatted for lookup purposes as text i.e. in a cell I'd enter '123,
gt; '345, '874, etc.
gt;
gt; Is this possible?

The problem arises when importing an ASCII file which contains the
balances from a General Ledger in trial balance format, and also the
account reference which is alpha-numeric (some of the GL accounts have
a small alpha suffix).

Each GL account has a sheet in the workbook with the tab corresponding
to the GL account reference. I'm doing an indirect lookup on sheets
checking the sheet balances against the trial balance. Hence the
problem: the TB is in alphanumeric format and the tabs are in number
format.

If I can format the tab numbers as 'text' numbers end of problem.

Thanks--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=505267The tabs are text, try trimming your worksheet values
www.mvps.org/dmcritchie/excel/join.htm#trimall
and trim your tab values before you create them.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Brisbane Robquot; gt; wrote in message
news:Brisbane.Rob.22ae41_1138354206.5099@excelforu m-nospam.com...
gt;
gt; The problem arises when importing an ASCII file which contains the
gt; balances from a General Ledger in trial balance format, and also the
gt; account reference which is alpha-numeric (some of the GL accounts have
gt; a small alpha suffix).
gt;
gt; Each GL account has a sheet in the workbook with the tab corresponding
gt; to the GL account reference. I'm doing an indirect lookup on sheets
gt; checking the sheet balances against the trial balance. Hence the
gt; problem: the TB is in alphanumeric format and the tabs are in number
gt; format.
gt;
gt; If I can format the tab numbers as 'text' numbers end of problem.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread: www.excelforum.com/showthread...hreadid=505267
gt;