Data issue after exporting

[himabinduch]

HI All,

I have a  straight table in my application and i have huge data.

when i am exporting data to excel i am facing some issue my data

one of the text field convert into date format.

my data as below. mu line number suppose to be 1-4,1-3,1-2  like that.

order#	Line number	change date	operating unit	change by name
834680	1-Apr	########	QTIL OU	NCHOU
834680	1-Apr	########	QTIL OU	NCHOU
834680	1-Apr	########	QTIL OU	FEEDER SYSTEM
834680	1-Apr	########	QTIL OU	FEEDER SYSTEM
834680	1-Apr	########	QTIL OU	FEEDER SYSTEM
834680	1-Apr	########	QTIL OU	FEEDER SYSTEM
838390	1-Mar	########	QTIL OU	SHERRYL
838390	1-Mar	########	QTIL OU	SHERRYL
838390	1-Mar	########	QTIL OU	FEEDER SYSTEM
838390	1-Mar	########	QTIL OU	FEEDER SYSTEM
838390	1-Mar	########	QTIL OU	FEEDER SYSTEM
838390	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Mar	########	QTIL OU	C_LHE
842877	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Mar	########	QTIL OU	KANDY
842877	1-Mar	########	QTIL OU	C_LHE
842877	1-Mar	########	QTIL OU	C_LHE
842877	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Mar	########	QTIL OU	FEEDER SYSTEM
842877	1-Apr	########	QTIL OU	KANDY
842877	1-Apr	########	QTIL OU	C_LHE
842877	1-Apr	########	QTIL OU	FEEDER SYSTEM
842877	1-Apr	########	QTIL OU	FEEDER SYSTEM
842877	1-Apr	########	QTIL OU	FEEDER SYSTEM
842877	1-Apr	########	QTIL OU	FEEDER SYSTEM
838804	1-Nov	########	QTIL OU	KANDY
838804	1-Nov	########	QTIL OU	KANDY
838804	13-1	########	QTIL OU	KANDY
838804	13-1	########	QTIL OU	KANDY
842090	1-Apr	########	QTIL OU	CONNIEK
842090	1-Apr	########	QTIL OU	CONNIEK
842090	1-Apr	########	QTIL OU	FEEDER SYSTEM

[trdandamudi]

Did you tried to select "Number" or " Expression Default" in the Number tab ?

[rakeshkumar1890 · Accepted solution]

Put on your dimension like that - Double Quote with space and your field name

" " &[Line number]

[shiveshsingh]

Change the format of that column to Text.

[himabinduch]

Hey it worked for me

[rakeshkumar1890]

I think, you got your result, if ok please close this thread.

also you can use it

text([Line number])