Hi Ronald,
What about running following macro first, and then sorting the
dolumn...
Greetings
Paul Willekens
'===
Sub Omzetten()
Dim nRow
nRow = 1
While Len(Cells(nRow, 1)) > 0
If IsNumeric(Cells(nRow, 1).Value) Then
C
I want to force numbers in a combined text number column to look like text
but be sorted as numbers. I tried the cell select and changed format of
column to text
but when I try and export the data to a specialized program like Monarch Pro
V 10.5
Monarch interprets the numbers as numbers and in a c