excel - SSRS Exporting to CSV format -

excel - SSRS Exporting to CSV format -

when export info csv file in raw info format , used in 1 of fields have number big (for example, 140313055811). it's invoice number, when export csv , open it, shows 1.41e+11. need display total number instead of this. there way? tried making textbox in number, tried create value area of field =int(name of field), tried changing text. none of these trick.

the 1 has worked =formatnumber(fieldname) , while did work, set commas in between if big number (this invoice number). thinking utilize =format function when asks "style string" in look put?

i need study automated on enterprise sharepoint site that's why going through great lengths seek automatically come out right.

exporting excel form makes hard utilize data, csv form best way manipulate data.

thanks help, appreciate it

if check csv file in notepad, might find value scientific number before making excel.

you can stick spaces in front end and/or behind value create csv file right (and treat text), excel create scientific 1 time again anyway moment opened , sees numbers.

the solution know of export used in excel, stick real character string "inv: " before value , deal in excel file.

= "inv: " & fields!invoicenumber.value

so reads "inv: 1230412893481239435" text.

excel csv reporting-services ssrs-2008