d68fbe50/Byte Formatting for Google Sheets.md

Forked from loganvolkers/Byte Formatting for Google Sheets.md

Created August 8, 2023 02:58

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/d68fbe50/d86e44b34c70f21b0e44e3e6cc6769ee.js"></script>
Save d68fbe50/d86e44b34c70f21b0e44e3e6cc6769ee to your computer and use it in GitHub Desktop.

Download ZIP

Byte formatting for Google Sheets

Raw

Byte Formatting for Google Sheets.md

Custom format for displaying bytes as kb, mb, gb or tb.

Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc

Here is one that I have been using:

[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

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