Formatting in Excel 2007

J

Jennifer

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel 2007 won't stop rounding down my formula results! 5
How to stop Excel from rounding a number? 3
Excel Stop Excel from displaying rounded values 4
Format Cell Problem 3
negative number format 1
Number format issue Access 2007 2
Custom number format 1
Decimal Field's Precision Too Small to accept the numeric you ... 3

Top