[Ham-Computers] Excel Problem with Zeroes

[WA5CAB at cs.com]

Thanks.  But I had already tried that.  It isn't sticky.  After changing 
the cell format for the column in question to text, inserting the leading 
zeroes and saving the file, next time you open it, even if you change the cell 
format again to text, it does not show the zeroes.  I corrected all of the 
September and earlier Date Groups with Notepad and saved the file.  Then 
opened it again with Excel and reset the column to text and the zeros still 
aren't displayed.  And if you save the file like that, the leading zeroes that 
were in fact actually in the file are all deleted.  Totally unsat!  MS Know's 
Best strikes again.

In a message dated 03/13/2012 22:18:35 PM Central Daylight Time, 
ad5pe at sbcglobal.net writes: 
> It's because numbers don't have leading zeros, being insignificant digits 
> in
> mathematical terms.
> 
> Open the CSV, then highlight the part number column and change the format 
> to
> "text".
> 
> 73,
> Jay
> AD5PE
> 
> -----Original Message-----
> From: ham-computers-bounces at mailman.qth.net
> [mailto:ham-computers-bounces at mailman.qth.net] On Behalf Of WA5CAB at cs.com
> Sent: Tuesday, March 13, 2012 22:00
> To: Ham-Computers at mailman.qth.net
> Subject: [Ham-Computers] Excel Problem with Zeroes
> 
> Does anyone know how to make MS Excel 2000 cease deleting leading zeroes 
> in
> numeric strings?  I normally use a database for any sort of list, 
> including
> part numbers.  But have a case where the only file format I can upload to 
> a
> site is a .CSV.  And the only viewer/editor I have for .CSV's is Excel.  
> Which screws up all of those numbers that have leading zeroes.
> 

Robert & Susan Downs - Houston
wa5cab dot com (Web Store)
MVPA 9480