What are the number formats to use when cycling through formats?
Hi all - I've been using format cycling like the below for my formatting
#,##0" ";(#,##0);"– "
#,##0%" ";(#,##0%)" ";"– "
However, I recently learned about the "_" option and now use in my custom formatting
#,##0_);(#,##0);"–"_)
#,##0%_);(#,##0%)" ";"–"_)
Just wondering what is the "most correct" formatting to use in Excel? Is my second option correct?
Consequatur ea esse et facilis ut accusantium. Sed vel et voluptas occaecati in. Doloremque possimus non expedita.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...