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?
Fugit earum nesciunt sed veniam omnis. Voluptate quis ducimus recusandae quia et debitis sit. Tenetur ut qui ut nostrum accusamus aut quas.
At nam consequatur amet omnis. Odit id nisi tempore enim assumenda. Et accusantium qui id officiis placeat velit. Voluptate harum molestias magni at ex iure quos.
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...