导航
故乡首页
电脑技巧
设计点滴
轻松办公
实用软件
朝花夕拾
世界名人
地球名胜
编程学习
英语小屋
环球扫描
养生之路
标签
[置顶] 牛牛记事官方发布2022 v3.6
2009年5月29日
excel身份证号码显示问题
默认情况下,数字位数超过11位时excel会使用科学计数法,这样身份证号码以及一些比较长的数字就不能全部显示了。解决方法:1.如果还没输入号码:把身份证号码所在的列设置成文本格式,比如身份证放在C列就右键点击字母C,设置单元格格式,数字栏目中选文本,然后确定。(注意,如果已经输入身份
阅读全文...
| 分类:
轻松办公
| 评论:0 | 引用:0 | 浏览:
2009年5月7日
EXCEL之COUNTIF函数
EXCEL中的COUNTIF函数有着强大的逻辑功能,请看小例如:要用COUNTIF()来统计单元格F3~F22中数值大于90的数据的个数。 80~90(不包括80与90) =countif(f3:f22,">80")-countif(f3:f22,">=90") (包括80与90) =countif(f3:f22,&
阅读全文...
| 分类:
轻松办公
| 评论:0 | 引用:0 | 浏览:
2009年4月29日
EXCEL 时间输入快捷键
EXCEL 时间输入快捷键 1. 任意日期与时间的输入 数字键与“/”或“-”配合可快速输入日期,而数字键与“:”配合可输入时间:如输入“3/25”,然后回车即可得到“3月25日”。又如输入“9:25”,回车即得到
阅读全文...
| 分类:
轻松办公
| 评论:0 | 引用:0 | 浏览:
2009年4月28日
用excel求已知坐标角度
A1为X坐标,A2为Y坐标公式=TEXT(DEGREES(ATAN(A1/A2))/24,"[h]""°""m""'""s!""")动手试试吧
阅读全文...
| 分类:
轻松办公
| 评论:0 | 引用:0 | 浏览:
分页:
«
1
2
»
常用链接
落日小程序下载
牛牛记事
内容搜索
赞助商
文章归档
2019 November
(1)
2019 September
(4)
2018 September
(1)
2018 April
(1)
2018 March
(1)
2018 February
(1)
2017 October
(1)
2017 September
(2)
2017 August
(1)
2017 May
(1)
2016 June
(2)
2016 February
(1)
2016 January
(3)
2015 December
(5)
2015 November
(6)
2015 October
(4)
2015 September
(1)
2015 June
(3)
2015 May
(1)
2015 April
(1)
2015 February
(3)
2015 January
(1)
2014 December
(2)
2014 September
(1)
2014 August
(4)
2014 July
(11)
2014 March
(1)
2014 January
(3)
2013 December
(1)
2013 November
(1)
2013 October
(2)
2013 September
(4)
2013 June
(4)
2013 May
(2)
2013 April
(1)
2013 March
(3)
2013 February
(3)
2013 January
(4)
2012 December
(5)
2012 November
(9)
2012 October
(3)
2012 September
(7)
2012 August
(4)
2012 July
(1)
2012 June
(1)
2012 May
(1)
2012 April
(2)
2012 March
(3)
2012 February
(1)
2012 January
(3)
2011 December
(1)
2011 November
(4)
2011 October
(2)
2011 September
(3)
2011 August
(2)
2011 July
(4)
2011 June
(6)
2011 May
(2)
2011 April
(4)
2011 March
(4)
2011 February
(4)
2011 January
(5)
2010 December
(3)
2010 November
(4)
2010 October
(7)
2010 September
(8)
2010 August
(5)
2010 July
(2)
2010 June
(3)
2010 May
(3)
2010 April
(4)
2010 March
(4)
2010 February
(8)
2010 January
(11)
2009 December
(17)
2009 November
(24)
2009 October
(25)
2009 September
(22)
2009 August
(21)
2009 July
(20)
2009 June
(43)
2009 May
(47)
2009 April
(12)
Power By Z-blog
Copyright spersky All Rights Reserved.Theme Moonlight,Calf modified.n
浙ICP备16017820号-1