I have a value in a cell that's in bytes. But nobody can read 728398112238. I'd rather it say 678.37GB
To write a formula to format it is relatively easy (here's one: http://www.yonahruss.com/2007/02/format-excel-numbers-as-gb-mb-kb-b.html)
But is there any way to do this as a 'format'? I'd like to have the big number in the cell, but have it displayed in a human-readable format.
In Excel's formatting features, computations are not actually possible. To make a ballpark estimate, you may use something like this:
[<500000]#,##0" B";[<500000000]#,##0,," MB";#,##0,,," GB"
To do what you want is like ...READ MORE
There are various difficulties in this. Which ...READ MORE
This one is tested and does work ...READ MORE
Looks like you could use:
The formula in D2:
=SUBSTITUTE(F ...READ MORE
Its not possible. What you could do is ...READ MORE
The row number used in the formula ...READ MORE
Where #.##0,00 € would do for ...READ MORE
Copy the next event code in the ...READ MORE
Private Scan As Integer
Private Sub CommandButton1_Click() ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.