Keep Leading Zeros

[JMWDBA]

 Other than converting a number column to Text is there any other way to keep the leading zeros on numbers in a column and also keep the column formatted as a Whole Number?  The ID's are supposed to be 7 digits but when the leading zeros are dropped some of them drop to 4 digits and in some cases 5 digits because the other digits were zeros. 

[Ashish_Mathur]

Hi,

In a calculated column, write this formula

=FORMAT(Data[column],"0000000")

Hope this helps.

[Greg_Deckler]

@Ashish_Mathur- That converts it to Text, which is what he is trying to avoid.

[Greg_Deckler]

Not that I am aware of.