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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top