Display or hide all zero values on a worksheet
1. Click the Microsoft Office Button Button image, click Excel Options, and then click the Advanced category. 2. Under Display options for this worksheet, select a worksheet, and then do one of the following: § To display zero (0) values in cells, select the Show a zero in cells that have zero value check box. § To display zero values as blank cells, clear the Show a zero in cells that have zero value check box. From: [email protected] [mailto:[email protected]] On Behalf Of Mitch Mueller Sent: Wednesday, May 06, 2009 3:45 PM To: [email protected] Subject: RE: [info-tech] CSV files How about with office 2007? Mitch Mueller Network Administrator Emmetsburg Community Schools Emmetsburg, Ia 50536 [email protected] 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: "Jason kehoe" <[email protected]> Sent: Wednesday, May 06, 2009 3:43 PM To: [email protected] Subject: RE: [info-tech] CSV files Display or hide all zero values on a worksheet On the Tools menu, click Options, and then click the View tab. Do one of the following: To display zero (0) values in cells, select the Zero values check box. To display zero values as blank cells, clear the check box. --Jason From: [email protected] [mailto:[email protected]] On Behalf Of Mitch Mueller Sent: Wednesday, May 06, 2009 3:30 PM To: [email protected] 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 [email protected] 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.
<<image001.gif>>
