# 常用小工具

# Excel流量单位自动转换

单元格格式使用自定义，然后填入以下格式

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

[![image.png](https://bookstack.freedom-yun.com/uploads/images/gallery/2024-01/scaled-1680-/OhhqncOjkPLj4lGb-image.png)](https://bookstack.freedom-yun.com/uploads/images/gallery/2024-01/OhhqncOjkPLj4lGb-image.png)