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 |
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 |
All times are GMT +1. The time now is 03:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com