How can I Count to see if the amount of Characters in a cell is odd and if it is, add a 0 to the front of the cell

[popcornrulez]

So lets say that the cell A1 has the number 900 in it. What I want to do is put a formula in B1 that checks to see if A1's character count is odd and if it is odd, then add a 0 in front of the original number from A1. Here's an example.

COLUMN A COLUMN B
ROW 1 900 0900


popcornrulez

 

[RonB1111]

If you want to display 4 digits and retain the cell value as a number, use Format Cells - Number Tab - Custom - and type in 0000 in the box underneath Type (on the right side of the screen).

If you want to convert the numeric numbers to text, use this formula: =TEXT(A1,"0000")

Let me know if you're looking for something else because a formula for your specific request to add a 0 in front of an odd length number would result in the number 7 becoming 07, but I suspect you're looking for 0007.

 

[JoeMo]

So lets say that the cell A1 has the number 900 in it. What I want to do is put a formula in B1 that checks to see if A1's character count is odd and if it is odd, then add a 0 in front of the original number from A1. Here's an example.

COLUMN A COLUMN B
ROW 1 900 0900







popcornrulez

Excel Workbook
	A	B
1	900	0900
Sheet5

 

[popcornrulez]

Thanks JoeMo that works for what I was trying to do. As for Ron, I needed this formula to work for any amount of digits, not just four.


popcornrulez