27th July 2011, 08:22 AM
|
|
Member
|
|
Join Date: Mar 2006
Posts: 112
|
|
Quote:
|
Originally Posted by Dennis G
.
I might go to MrExcel to see if I can find a solution.
|
Not much joy there either. The only response I got was - "If the cell format is "General" it takes the value as you have indicated.
However, if cell format is "Text" then it remains as it is!
Did you try formatting first 2 columns to text?" and now buried on page 12  |