skip to main | skip to sidebar

puretechie

Our technical scratch pad

Tuesday, February 20, 2024

How to custom format in excel

Source: https://www.ablebits.com/office-addins-blog/custom-excel-number-format/#decimal-places

Converting a number to MILLIONS in currency without dividing the number by 1000000.

$* #,##0.00,,"M";;"";

Posted by Shantanu at Tuesday, February 20, 2024

No comments:

Post a Comment

Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Shantanu
shantanugudihal.com
View my complete profile

Links

  • phrack magazine

Blog Archive

  • ▼  2024 (4)
    • ▼  February (2)
      • How to custom format in excel
      • Excel validating whether required columns (marked ...
    • ►  January (2)
  • ►  2023 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  September (1)
  • ►  2013 (3)
    • ►  July (2)
    • ►  June (1)
  • ►  2012 (4)
    • ►  December (1)
    • ►  November (2)
    • ►  October (1)
  • ►  2011 (2)
    • ►  October (1)
    • ►  February (1)
  • ►  2010 (1)
    • ►  August (1)
  • ►  2009 (4)
    • ►  December (1)
    • ►  September (1)
    • ►  July (1)
    • ►  February (1)
  • ►  2008 (8)
    • ►  October (1)
    • ►  September (2)
    • ►  June (1)
    • ►  May (3)
    • ►  April (1)
  • ►  2007 (20)
    • ►  November (1)
    • ►  October (4)
    • ►  August (1)
    • ►  June (2)
    • ►  May (2)
    • ►  April (1)
    • ►  March (5)
    • ►  February (4)
  • ►  2006 (26)
    • ►  December (2)
    • ►  October (2)
    • ►  September (2)
    • ►  August (5)
    • ►  July (3)
    • ►  June (1)
    • ►  April (3)
    • ►  March (1)
    • ►  February (3)
    • ►  January (4)
  • ►  2005 (1)
    • ►  December (1)