View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default sorting excel data

what does your macro say?

" wrote:

Thanks Ron!

this seems to work nicely. Only problem I have now, is that if i try
to record this method into a macro, that _all_ my data receive their
extra '0' after the dash, so in some way the selection method for
numbers with only 1 digit behind the dash is not recorded into the
macro (ie: 60000-12 becomes 60000-012, which is not supposed to
happen). Can anybody help me out with that?

thanks in advance,
Leon

On 11 jul, 15:04, Ron Coderre
wrote:
You might be interested in resolving the basic issue....

[snip]

Is that something you can work with?
***********
Regards,
Ron