View: Convert human readable sizes (K,M,G) to bytes in excel

  1. 5 years ago by spirit
    SI(SIERREUR(TROUVE("K";F107); 0); GAUCHE(F107;TROUVE("K";F107)-1)*1024;SI(SIERREUR(TROUVE("M";F107); 0); GAUCHE(F107;TROUVE("M";F107)-1)*1024*1024;SI(SIERREUR(TROUVE("G";F107); 0); GAUCHE(F107;TROUVE("G";F107)-1)*1024*1024*1024;F107)))
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2172"></script>

0 comment about "Convert human readable sizes (K,M,G) to bytes in excel"