Re: $$Excel-Macros$$ Want to forece numbers to look like text with Green Error Flag

2010-04-20 Thread paulwillekens
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

$$Excel-Macros$$ Want to forece numbers to look like text with Green Error Flag

2010-04-19 Thread Ronald Cayne
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