Datatable cuts off 0’s at beginning of account codes

  • Questions
  • Datatable cuts off 0's at beginning of account codes
Question ID: 104752
1
0

We’re putting account codes in the datatable to be used for account lookup in our application. The problem is, some of the account codes have 0’s at the beginning and those 0’s are being cut off when we put them into the datatable. How can we get the datatable to retain the 0’s?

Marked as spam
Posted by (Questions: 339, Answers: 20)
Asked on December 12, 2012 7:08 pm
7 views
Answers (1)
1
Private answer

All you need to do for values that begin with 0 is put a single quote ' at the beginning of the value. This should work with any character that the datatable doesn't retain when its the first character, such as 0 and '

Marked as spam
Posted by (Questions: 16, Answers: 749)
Answered on December 12, 2012 8:19 pm
That worked great! Thanks!!
( at December 12, 2012 8:21 pm)