Skip to content

Instantly share code, notes, and snippets.

@geeksareforlife

geeksareforlife/Excel.md

Last active October 31, 2017 15:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save geeksareforlife/93d8c7255f6e2ae2f1cf87a4f7214bbd to your computer and use it in GitHub Desktop.
Save geeksareforlife/93d8c7255f6e2ae2f1cf87a4f7214bbd to your computer and use it in GitHub Desktop.
Download ZIP
Excel Tips and Tricks
Raw
Excel.md

Sopme tips and tricks for Excel

Raw
Formatting.md

General

Four parts to the code, seperated by ;:

  • Code for numbers > 0
  • Code for numbers < 0
  • Code for zero
  • Code for text

Currency

In thousands, with currency lined up

_-£* [>=1000]#,##0.0,"K"_-;-£* [<=-1000]#,##0.0,"K"_-;_-£* "-"_-;_-@_-

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment