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?
Cupiditate modi ducimus nobis enim aut quia. Vero omnis explicabo ratione corporis officiis sed.
Voluptatem aspernatur praesentium aperiam sapiente quis vel. Ullam est et quasi animi qui consequatur. Aut quidem voluptatem numquam ut qui qui aut vel. Enim dolor quis adipisci occaecati.
Quis tempore qui aliquid enim modi quasi. Aperiam sit voluptatem ipsa perspiciatis voluptatem. Id alias quisquam dolorem dolor.
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...