Ok. I got that part. Now how about if I want to do that to all 465 of my cells?
Mitch Mueller Network Administrator Emmetsburg Community Schools Emmetsburg, Ia 50536 mmuel...@emmetsburg.k12.ia.us P: (712)852-2966 C: (712)298-0596 The best computer is a man and it's the only one that can be mass-produced by unskilled labor. ---------------------------------------- From: "Buenz, Tim" <tbu...@jefferson-scranton.k12.ia.us> Sent: Wednesday, May 06, 2009 3:35 PM To: "'info-tech@aea8.k12.ia.us'" <info-tech@aea8.k12.ia.us> Subject: RE: [info-tech] CSV files Format the password column as text instead of numbers. ----- Tim Buenz Director of Technology Jefferson-Scranton Comm. Schools 204 W. Madison Street Jefferson, IA 50129 (515)386-9256 Fax (515)386-3591 http://www.jscsd.org "Change is the law of life. And those who look only to the past or present are certain to miss the future" -John F. Kennedy ---------------------------------------- From: info-tech-ow...@aea8.k12.ia.us [mailto:info-tech-ow...@aea8.k12.ia.us] On Behalf Of Mitch Mueller Sent: Wednesday, May 06, 2009 3:30 PM To: info-tech@aea8.k12.ia.us Subject: [info-tech] CSV files Need some help with CSV files on Excel. trying to export the following to a csv file: Username | First Name | Last Name | Password mmueller Mitch Mueller 781 But I need to put 0's in front of my password so that I have a total of 5 characters and when I save it as a CSV File it take our the 0's in front of my password. And when I try to type them in manually it does not put them in there either. Any suggestions. Mitch Mueller Network Administrator Emmetsburg Community Schools Emmetsburg, Ia 50536 mmuel...@emmetsburg.k12.ia.us P: (712)852-2966 C: (712)298-0596 The best computer is a man and it's the only one that can be mass-produced by unskilled labor.