format the column
On May 6, 2009, at 3:38 PM, Mitch Mueller wrote:
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.
--
"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs, and the Universe trying
to produce bigger and better idiots. So far, the Universe is winning."
~ Rich Cook
--
Lance L. Lennon
District Technology Director
Eagle Grove Community School District
515-448-4749