formatting help

[tony4davina]

How do I filter my cells to enable me to put 2 zero's at the begining of a number without converting it to text.

[arthurbr]

How do I filter my cells to enable me to put 2 zero's at the begining of a number without converting it to text.

Hi,
I don't understand what you mean by filtering cells to put 2 zeroes at the beginning ?
But if you only want to change the format, right-click your cell, choose "Format cells"
Select " Custom"
In the text box "Type" type 00###### ( depending on the max length of your number)
Then OK

[amy22x3]

I've had this problem before and how I've worked around it is using the "concatenating" formula. Because just changing the formating doesn't work in all situations, at least not in my experience. Any first insert two columns in front of, or behind your existing data. Highlight the first column and change the format to "Text" and then type 00. In the second column, type "concatenate(a1,b1)", that will bring both the column test together. The new number will be a formula, so you'll need to convert it, also there's been times when I had to change the format to "Text".