Forum Discussion

JMWDBA's avatar
JMWDBA
Icon for Advocate II rankAdvocate II
8 years ago

Keep Leading Zeros

 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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

In a calculated column, write this formula

 

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

 

Hope this helps.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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