zeros before numbers

  1. P

    How can I make it so that a cell is formatted to the point where whatever number I type in stays the exact way that I typed it

    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. popcornrulez
  2. S

    Retaining preceding zeros when passing data to and from .txt files

    Hi, 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...
  3. G

    Dropping Zeros, But In A Formula?

    Hello Everyone, 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: =IF(OR(A1=TR002,A1=TR050),"Yes","No"))...
  4. P

    Hyperlink, cell data with zeros

    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> <o:p> </o:p> =HYPERLINK("c:\testing\123\Map"&b2&".pdf",b2)<o:p></o:p> <o:p></o:p> The column...

Some videos you may like

This Week's Hot Topics