G
Guest
I want to display in a cell -9048.00 as (9048.00)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
apply the following custom format (goto 'format - Cells'):
0.00;(-0.00)
apply the following custom format (goto 'format - Cells'):
0.00;(-0.00)
T
Trevor Shuttleworth
Mariah
Format | Cells... | Number tab | Custom | Type: #,##0;(#,##0)
Regards
Trevor
Format | Cells... | Number tab | Custom | Type: #,##0;(#,##0)
Regards
Trevor
F
Fred Smith
Right click on the cell, choose Format Cells... Click on Number under
Category:
Then choose how you want negative numbers displayed.
Category:
Then choose how you want negative numbers displayed.
N
Norman Harker
Hi Mariah!
If this will always be your preferred format you can change the format
for negative numbers using:
Start > Settings > Control Panel > Regional Options
Make changes on the Numbers and Currency Tabs
Apply
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
If this will always be your preferred format you can change the format
for negative numbers using:
Start > Settings > Control Panel > Regional Options
Make changes on the Numbers and Currency Tabs
Apply
OK
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
G
Guest
2)Choose format,cells on the tool bar or-----Original Message-----
I want to display in a cell -9048.00 as (9048.00)
.
1)Right click on the cell or
3)Press CTRL 1
then click the Number tab and choose how you want the
number to display on the right side of the window
Beach