loganvolkers/Byte Formatting for Google Sheets.md

Last active September 29, 2025 14:20

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

Byte formatting for Google Sheets

Raw

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

Here is one that I have been using:

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

thanks friend, this helped a ton

extremely helpful — thanks 🙏

Here is a simple one for bytes to Gb:

=Round(H8 / (1024 * 1024 * 1024),2) &" GB"