Forum Discussion
data validation
the data that i exported form other program has column with values "8-2271" (the last 4 numbers are different), but in excel show me like date aug.71 in cell, but up in functions show me in format li...
NikolinoDE I am using excel 2013. The exporting from the program that i made it, it's in csv format. The program it's made it only for us. I am sending excel document to can see what is the problem. Please see column Box (D). For ex. data in cell D2 should to be 8-1971. From the program where i am exporting data is 8-1971, not like date.
OS? mac, windows? what windows?
NikolinoDE windows 2007
If open csv file by Excel it do default transformation which practically is not possible to avoid. Workaround is to import csv file and on third step of the wizard mark proper columns as Text type. Result will be like
