Changing displayed values

[Jim May]

After importing data in column D I have (sample):
BANK ACCT.
370965
11936133607
11936133607
11936133607
5134163722
850963060
1.01009E+12 <<< s/b 1010086655918
1.01009E+12 <<< s/b 1010086655918
11936133607

I'd like to select range D250 and run Macro
that will convert only those cells that are producing
the 1.01009E+12 gibberish above s/b = actual contents

Using Selection For Each loop
how would I test for = TRUE for the 1.01009E+12's and the
like?
TIA,

 

[RagDyer]

If you're getting 11 digit account numbers displayed properly, meaning the
format is being recognized correctly by XL, just for fun, before you do
anything else, just make the column wider and see what happens!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

After importing data in column D I have (sample):
BANK ACCT.
370965
11936133607
11936133607
11936133607
5134163722
850963060
1.01009E+12 <<< s/b 1010086655918
1.01009E+12 <<< s/b 1010086655918
11936133607

I'd like to select range D250 and run Macro
that will convert only those cells that are producing
the 1.01009E+12 gibberish above s/b = actual contents

Using Selection For Each loop
how would I test for = TRUE for the 1.01009E+12's and the
like?
TIA,

 

[Jim May]

Tried that first, but no cigar!!
What next?

 

[RagDyer]

Sometimes, when the cell is originally formatted to General, larger numbers
will truncate to the scientific notation *before* it displays the ### signs.

If your numbers are less then 15 digits, have you tried formatting your
cells to "Number", with *no* decimal places?
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Tried that first, but no cigar!!
What next?

 

[Guest]

It's Lite up time!!
IOW .. Got the cigar, you might say..
Longing to use a VBA solution I had
forgotten to consider using the format, number
simplicity; thanks for reminding me.