Hi there
I have a strange anomaly with a worksheet. I am pulling data from another worksheet (.xlsx) where all cells are formatted to General and I can "see" bank accounts and sort codes that start with zero without any problems. However, when I import the data in to another workbook - all cells are formatted as General, the cells that should show the sort codes and bank accounts that start with zero are missing. I am completely stumped by this as I thought that this was initially just a formatting issue but other cells that have a zero as the start of a number display fine! I have attached the source data sheet and the workbook that does all the work so you can view the problem. Just need to connect at A2 in Optimy sheet.
Many thanks in advance
Tony
Bookmarks