If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting in Excel 2007
I just got Excel 2007. I'm exporting from an SSRS report to Excel.
One of the fields being exported is an identifying number. It is coming accross as 2.00309e+006. I can't get it to look like a regular number. I've tried formatting it as a number with no decimal places. I've tried the same with Currency and Accounting. I've tried Text as well. Please help. Thanks, Jennifer |
#2
|
|||
|
|||
Formatting in Excel 2007
When Excel se something like 123E5 it reads this as 123x10^5
So your identify 'number' is being read as a number not a text Any chance of changing the SSRS file so that field looks like text to Excel (a letter as leading character, for example)? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jennifer" wrote in message ... I just got Excel 2007. I'm exporting from an SSRS report to Excel. One of the fields being exported is an identifying number. It is coming accross as 2.00309e+006. I can't get it to look like a regular number. I've tried formatting it as a number with no decimal places. I've tried the same with Currency and Accounting. I've tried Text as well. Please help. Thanks, Jennifer |
Thread Tools | |
Display Modes | |
|
|