Skip to content

Making Life Simple

Tech Tips and Tricks

Menu

Primary menu

  • Home

Month: February 2010

CSV to Excel – keep leading zeros

Posted on February 9, 2010 by lalit — No Comments ↓

When opening a csv file in excel, leading zero’s are displaced as below: if the CSV file has “010101”, when opened in excel, it becomes “10101”. To overcome this issue, store data in CSV file as =”010101″ (add ‘equals’ sign Continue reading CSV to Excel – keep leading zeros→

Posted in Windoze | Leave a reply

Primary Sidebar Widget Area

Recent Posts

  • Unable to run metrics-server in K8 cluster
  • Switched to Ubuntu from Windows
  • Enable minimize on click
  • Enable Mate desktop with vnc
  • SHA Collision

Recent Comments

  • kinogo on How to check GMail RSS/Atom feed
  • http://activeedgenutrition.com on How to check GMail RSS/Atom feed
  • tester on How to check GMail RSS/Atom feed
  • Sweety Mehta on How to create RoR app with PostgreSQL support
  • lalit on Oracle XE Tuning

Archives

  • April 2021
  • August 2020
  • January 2020
  • December 2019
  • July 2019
  • July 2018
  • March 2016
  • May 2015
  • March 2015
  • September 2014
  • July 2014
  • April 2014
  • November 2013
  • October 2013
  • August 2013
  • July 2013
  • June 2013
  • March 2013
  • October 2012
  • August 2012
  • May 2012
  • January 2012
  • November 2011
  • August 2011
  • July 2011
  • June 2011
  • March 2011
  • February 2010
  • January 2010
  • September 2009
  • July 2009
  • January 2009
  • December 2008
  • August 2008
  • July 2008
  • June 2008
  • May 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • June 2007
  • March 2007
  • February 2007
  • January 2007
  • December 2006
  • November 2006
  • October 2006
  • September 2006
  • August 2006
  • July 2006
  • June 2006
  • May 2006
  • April 2006
  • March 2006
  • February 2006
  • January 2006

Categories

  • apache
  • css
  • general web
  • git
  • hibernate
  • java
  • javascript
  • kubernetes
  • linux
  • mysql
  • news
  • oracle
  • php
  • python
  • RoR
  • struts
  • Uncategorized
  • Windoze

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 Making Life Simple. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up