Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Byte formatting for Google Sheets
Copy link

varenc commented Jun 20, 2021

kaustubhcs that works as a formula, and is nice for using actual binary bytes, but there's advantages to using a custom number format instead of a formula! (no secondary cell, copied values are still the original byte count, etc).

Google's very sparse docs on number formats:

Copy link

Smart123s commented Jul 4, 2021

Helped me out a lot. Thank you! :)

Copy link

eljeko commented Sep 14, 2021

Is what I was looking for, thank you!

Copy link

fordsho commented Sep 17, 2021

Thank you so much for this, It made my life so much easier!!

Copy link

caio-vinicius commented Sep 22, 2021

Thank you very much!

Copy link

alexstorer commented Oct 1, 2021

This is very useful! I can only get it to format 3 options, so if you want the MB/GB/TB version instead of the KB/MB/GB version, this looks like it works:

[<1000000000]0.00,," MB";[<1000000000000]0.00,,," GB";0.00,,,," TB"

Copy link

pkowaluk commented Apr 1, 2022

Nice work, OP. Thanks 🌟

Copy link

mcsherrylabs commented May 17, 2022

Many thanks.

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