Excel 2003: Formula to get 4 digits

[cepes]

Hi:
I need each cell to have 4 digits. For example, Cell A1 should have 4 digits

If number of Cell A1 digits < 4, add a zero to the front of the digits, otherwise leave alone.

So, if A1 = 292 would become 0292

Also, I guess if A1 = 92, it should become 0092

Thanks!

Charlie

 

[Aladin Akyurek]

hi:
I Need Each Cell To Have 4 Digits. For Example, Cell A1 Should Have 4 Digits

If Number Of Cell A1 Digits < 4, Add A Zero To The Front Of The Digits, Otherwise Leave Alone.

So, If A1 = 292 Would Become 0292

Also, I Guess If A1 = 92, It Should Become 0092

Thanks!

Charlie

Try...

B1:

=RIGHT("0000"&A1,4)

 

[DonkeyOte]

if it's purely a display issue format the cells using custom format of "0000"... 1 will show as 0001 but is still effectively 1

 

[cepes]

=RIGHT("0000"&A1,4) works perfectly!! Thank you-

 

[cepes]

Hi again:
A co-worker came up with this one too:

=IF(A1>9999,A1,RIGHT("0000"&A1,4))