Forum Discussion
JMWDBA
Advocate II
Advocate IIKeep 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 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.
3 Replies
- Greg_Deckler
Community Champion
Not that I am aware of.
- Ashish_Mathur
Super User
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.
