Formatting in Excel 2007

  • Thread starter Thread starter Jennifer
  • Start date Start date
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
 
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
Format Cell Problem 3
Number format issue Access 2007 2
Excel Stop Excel from displaying rounded values 4
negative number format 1
Excel Number Formatting 1
eliminating decimal places 4

Back
Top