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