View Single Post
  #1   Report Post  
Raida Raida is offline
Junior Member
 
Posts: 2
Default adding brackets to every cells without changing content

hi, i want to add brackets to some rows in my spreadsheet, i have tried ="("&A1&")", the thing is, some of my figures appear as small decimal (e.g. 8.63E-07) and and after using ="("&A1&")", it will change my figure to (0.000000863). is there anyway to present it as (8.63E-07)?