Forum Discussion
Negitive numbers
Simply select the desired column and use below formatting to convert numbers as negative.
You may also refer to the attached file for more clarity.
Thanks
Tauqeer
Thanks for a quick response!
I am not sure I am reading your pro tip correctly or if I didn't convey my dilemma appropriately?
I have 3838 entries that have been imported as $100.00 and I need to change them all to ($100.00).
I formatted the cells to Currency and selected the option $100.00 (in red) and then changed all the numbers to red hoping this would do the trick.
I am trying to avoid changing all 3838 cells manually.
Negative numbers aren't showing with parentheses in Excel
If you're using Excel and negative numbers aren't displaying with parentheses, you can change the way negative numbers are displayed. But if that doesn't work, or if the parentheses option ($1,234.10) isn't available, it's likely because an operating system setting isn't set properly. If you're using a Mac, make sure you use the App Store and update to the latest version of macOS. If you're using Windows, use one of the following solutions to change the negative number format. Keep in mind that changing the setting will affect all programs on your computer, not just Excel.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- Thank you for your time Nikolino!