#1   Report Post  
jordan
 
Posts: n/a
Default Number formatting

DOES ANYBODY KNOWE SEPARATOR DOES NOT WORK? IN THE SAMPLE BOX THE PARENTHESIS
ARE NOT DISPLAYED???????
ANY SUGGESTION HOW TO FIX THIS ISSUE
TAHNKS
JORDAN
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe....

Windows start button|settings|control panel|regional settings
(Or regional and language settings in winXP)

Regional Options tab, customize button in winxp

Currency Tab
change the negative currency format to show ()'s.

jordan wrote:

DOES ANYBODY KNOWE SEPARATOR DOES NOT WORK? IN THE SAMPLE BOX THE PARENTHESIS
ARE NOT DISPLAYED???????
ANY SUGGESTION HOW TO FIX THIS ISSUE
TAHNKS
JORDAN


--

Dave Peterson
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
Text Function with Different Formatting for Number MKenworthy Excel Discussion (Misc queries) 1 September 1st 05 11:34 PM
concatenating and formatting area code and phone number columns sherri Excel Worksheet Functions 4 September 1st 05 09:59 PM
Number Formatting Delaina Excel Worksheet Functions 3 June 9th 05 06:15 PM
Pivot Table Drill Down Number Formatting Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM
Conditional Formatting (Date vs Number) [email protected] Excel Discussion (Misc queries) 7 December 20th 04 10:23 PM


All times are GMT +1. The time now is 12:39 AM.

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"