How to make PM get long numbers from table

  • Автор темы Автор темы jcknick
  • Дата начала Дата начала

jcknick

Client
Регистрация
10.05.2013
Сообщения
154
Реакции
9
Баллы
18
I have long ID number of some products in my excel table, e.g.
2398742300934800000000000, but when I try to parse the table in PM, it's getting the number as 2,3987423009348E+24

How can I get the full number without these shortenings?
 
Load it like list, not table, if u can ofcs.
c2bd3e6a3f5476150ff17800b1ee3d7f.png

=)
Or needing of some C# snippet =)
 
List looks potentially a handful? :) Any way to do it in a more "civilized" way?
 
You must to convert your excel column to text.
At excel... =TEXT(A1,"#####################################################")

For zenno, everything is string, remember that.
 

Вложения

  • Sem título.png
    Sem título.png
    19,2 KB · Просмотры: 252

Кто просматривает тему: (Всего: 0, Пользователи: 0, Гости: 0)