Leading Zero reading from excel sheet

Hello all,

How to read the value from cell of a excel sheet with all leading values in columns.

using following code to read the column value

case COMVariantType::VT_R8      :
If my input is 00010 . it is giving me result as 10 only.

Kindly Suggest


You read a “double” value and that’s 10. There is nothing like a number 00010 distinct to 10. Leading zeros can be added, of course, when formatting a number to text. That’s exactly what you should do in AX (you can use num2str0() instead of num2str()).

Another approach would be to base the whole solution not on a numeric value, but on a text created by applying a format to the number in Excel.