[Ham-Computers] Excel Problem with Zeroes

[Mike]

  Not sure if this will aid you - from Excel help.

73, Mike NF4L


  When I apply the Text format to numbers, the numeric data doesn't change to text.

If you've already entered the numbers and applied the Text format to the cells, click 
each cell, press F2, and then press ENTER to reenter the numbers as text. To enter 
numbers as text, first apply the Text format to empty cells, and then enter the 
numbers in the formatted cells.


On 3/14/2012 12:30 AM, WA5CAB at cs.com wrote:
> 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
> ______________________________________________________________
> 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
>