ExcelBanter - Number formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number formatting (https://www.excelbanter.com/excel-discussion-misc-queries/48426-number-formatting.html)

jordan

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

Dave Peterson

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

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