jpg转换excel转换器_Excel转换功能变得简单

jpg转换excel转换器

Excel转换功能变得简单 (Excel CONVERT Function Made Easy)

Do you ever use the Excel CONVERT function? Do you avoid it, because you can't remember all the measurement unit codes? For example, the formula =CONVERT(10,"klt","gal") will convert 10 kilolitres to 2,641.7205 gallons – if you get those codes right. You might be able to remember lt and gal, but probably not many of the other codes.

您是否曾经使用过Excel CONVERT函数？ 是否因为忘记了所有测量单位代码而避免了它？ 例如，公式= CONVERT(10，“ klt”，“ gal”)将把10公斤转换为2,641.7205加仑–如果您正确地获得了这些代码。 您可能会记得lt和gal，但可能记不起来很多其他代码。

下拉单位列表 (Drop Down Lists of Units)

To make the CONVERT function easy to use, I created an Excel file, with lists of the unit categories, codes and the prefixes.

为了使CONVERT功能易于使用，我创建了一个Excel文件，其中包含单位类别，代码和前缀的列表。

First, you'll select a conversion type, from a drop down list