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)?
|