Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Comma format

How do I set the default comma format to show negative number as within
paranthesis. say -1234.567 as (1,234.57)

Can anyone help please ?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Comma format

FormatStyleNormalModifyCustom

#,##0.00_);[Red](#,##0.00)


Gord Dibben MS Excel MVP

On Tue, 17 Apr 2007 07:46:04 -0700, Raj wrote:

How do I set the default comma format to show negative number as within
paranthesis. say -1234.567 as (1,234.57)

Can anyone help please ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Format millions in thousands with comma Todd Excel Discussion (Misc queries) 3 April 9th 23 12:50 PM
Comma Deliminated File Format Olan Gotcher Excel Discussion (Misc queries) 5 July 16th 06 01:10 AM
Comma format button decimals Steve Ruiter Excel Discussion (Misc queries) 0 November 30th 05 06:51 PM
How do I save format changes in a comma delimited file? mariam0673 Excel Worksheet Functions 2 March 1st 05 05:37 PM
.CSV file format - comma or semi-colon antifashionpimp Excel Worksheet Functions 1 November 10th 04 01:18 PM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"