在excel表中如何设置公式或函数把数字自动转变成月份的英文简写!

分类: 作业答案 • 2021-12-19 18:35:29

问题描述：

在excel表中如何设置公式或函数把数字自动转变成月份的英文简写!
（例如：把数字1转成Jan）谢谢

答

=CHOOSE(A1,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")