Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Loses Formatting | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | New Users to Excel | |||
Excel 2007 Formatting | Excel Discussion (Misc queries) |