View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ezduzitez@gmail.com is offline
external usenet poster
 
Posts: 3
Default VBA question When I search to replace parentheses in excel itgives me "-" sign

Hello Garry,

I appreciate your support. My entire workbook is formatted as "Text" and when I run the macro it converts (.140) to -0.14 and I see the error telling me "Number Stored as Text". Is there a way I can work around this issue?

Thanks