How to achieve format with preceding 10 zeros to any digit in excel?

working with excel read range / write rang can have some uncontrolled result (interpretating 000…123 String as a number and removes the 0 on start.

  • better results we achieved on using EAS for read /write range
  • if needed we can do some corrections (LINQ, Datacolumn Expressions)
  • reformating Cell format with following activity:

in some scenarios forceing Excel with '000110 (the starting ') to keep values as text was accepted by some clients and was working

1 Like