Thread: Regular Expression Help on syntax
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Colbert Zhou [MSFT] Colbert Zhou [MSFT] is offline
external usenet poster
  
Posts: 19
Default Regular Expression Help on syntax
Hello Dan,

Based on my researches, if we want to identify the negative number, we can
use the following regular expressions,
^(-)?\D+(\d+)

Best regards,
Ji Zhou
Microsoft Online Community

Reply With QuoteReply With Quote