Thanks Tom;
One line BEFORE the line of code I showed previously is
a Paste-Special Values statement, which "converted"
my LocNumber (Cell B6) from its Source Value of 0000000000 - formated as Text
and dropped it in as '0000000000 in the Destination Cell B6

Currently, I'm adding two lines Prior to the Range("A5").select as follows:

Range("B6").Numberformat = "@"
Range("B6").FormulaR1C1 = "0000000000" <<< not happy with this line
But source
info will "Always"
Begin with
"0000000000" if there are any

Would prefer somehow just removing the " ' " being programmatically inserted
and maintaining the text format from the source..

Any suggestions?

with appreciation..
Jim May




"Tom Ogilvy" wrote:

Are any of your numbers actually stored as Text?

--
Regards,
Tom Ogilvy

"Jim May" wrote in message
...
In a macro I have

;;; Lines
;;; not shown..
Range("A5").Select
Selection.Sort Ket1:=Range("C5"), Order1:=xlDescending, Header:=xlguess, _
OrderCustom:=1, Matchcase:=False, Oreintation:=xlToptoBottom
End Sub

Prior to the lines shown above my spreadsheet shows
A B C
D
5 Bank LocNumber DepAmt DepDate << my
Headers
6 WC 0000000000 44.00 12/01/05
7 WC 0000000000 38.00 12/01/05

After the above Code runs it is reflecting:

A B C
D
5 Bank LocNumber DepAmt DepDate << my
Headers
6 WC 0000000000 44.00 12/01/05
7 WC 9541211111 600,000.00 12/06/05
8 WC 9541211111 598,000.00 12/21/05

and so on down to $1.00

Why is it NOT CHANGING/CONSIDERING ROW 6?

TIA,

Jim