Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab formating
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab formating
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab formating
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" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab formating
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab formating
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" wrote in message news:Brisbane.Rob.22ae41_1138354206.5099@excelforu m-nospam.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
IF Command conditional formating | Excel Worksheet Functions | |||
Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
Copy cell formating as part of a formula | Excel Worksheet Functions |