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.
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.
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
>
>
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("filename",A1),FIND("]",CELL("filename",A1))+1,255)
or in VBA
SheetName = Application.Caller.Parent.Name
see " Examples of assigning a sheetname" on my
http://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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Brisbane Rob" <[email protected]> wrote in message
news:[email protected]...
>
> 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?
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
The tabs are text, try trimming your worksheet values
http://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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Brisbane Rob" <[email protected]> wrote in message
news:[email protected]...
>
> 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: http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=505267
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks