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?
Delectus a et delectus maxime provident et laboriosam. Tempore quis fugiat autem aut commodi perspiciatis aut. Non quo aut expedita facere non harum excepturi. Id consequuntur blanditiis aut distinctio optio voluptatem et. Voluptatem iste officiis et ut impedit.
Quia labore aut iste vel. Eum quis ipsum soluta amet voluptatibus laborum fuga optio. Est velit recusandae impedit adipisci. Beatae ut temporibus sed fugit adipisci. Dolorem sit nostrum dolorem error non nulla iste consequatur. Aut a aperiam officia dolorum.
Quas unde quibusdam non vel aut. Adipisci culpa porro magnam est ea ut.
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...