[Ham-Computers] Excel Problem with Zeroes

[AD5PE]

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 Downs - Houston
wa5cab dot com (Web Store)
MVPA 9480
______________________________________________________________
Ham-Computers mailing list
Home: http://mailman.qth.net/mailman/listinfo/ham-computers
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Ham-Computers at mailman.qth.net

List Administrator: Duane Fischer, W8DBF
** For Assistance: dfischer at usol.com ** 


This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html