View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Jennifer[_2_] Jennifer[_2_] is offline
external usenet poster
 
Posts: 24
Default 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