show number in brackets

[coolbikesh]

can i show a number in brackets though in actual it is not without brackets.

for example: can i show 3456 in a cell a1 as (3456). though actually it is 3456 and can be used as number for all the other uses like formulas additions etc

 

[Michael M]

If the numbers are whole numbers, right click the cell>>Format>>NUmber>>Custom>>(#####)
if the decimal place is required..(#####.##)
Personally though....I would leave the numbers as they should be !

 

[JoeMo]

Right-click A1 and choose Format cells. Under Number tab choose Custom, then in Type enter "(0)" without the quote marks. Put whatever number format you want between the brackets.

 

[My Aswer Is This]

Yes:
1.Right click your cell
2.Choose “Format Cell”
3. Choose “Custom”
4. Click in box under “Type”
5 Type in (#)
6. Choose “OK”

 

[coolbikesh]

thankyou all..