Pretty much I just need to be able to have zeroes in front of numbers without converting the number to text. And also note that the numbers that I am going to be pasting in that cell need to be able to be any size and still be able to keep the zeroes in front of them.
I am trying to pass barcode data from excel to a text file and then back into excel. The barcodes are 8 or 12 character long and they can have or not have preceding zeros. I know of several ways to retain preceding zeros such as adding apostrophes before data or using custom formatting, but...
I know from time to time we have all dealt with excel issues involving the program dropping leading zeros, but this case is a first for me.
In order to monitor account numbers in a spreadsheet, I would like to setup a formula as follows:
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
I have a worksheet where the numbers in a column are linked to a pdf file<o:p></o:p>
The formula is:<o:p></o:p>