adding brackets to every cells without changing content

Raida

Junior Member

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Content in one coulumn using given content in another	Colin Hayes	Excel Worksheet Functions	4	March 28th 10 11:28 PM
Prevent formula from changing when adding in cells	Rhett C[_2_]	Excel Discussion (Misc queries)	2	October 2nd 09 09:35 PM
adding the same formula to several cells without changing cell lin	rcc	Excel Discussion (Misc queries)	7	October 17th 07 08:31 PM
adding quotations / brackets	kvedros	Excel Worksheet Functions	1	November 6th 06 06:42 AM
changing the colour of cells depending on the content.	johnny.exe	Excel Discussion (Misc queries)	3	January 26th 06 09:41 AM

All times are GMT +1. The time now is 08:20 PM.

Menu

About Us