Posted to microsoft.public.excel.newusers

Jennifer[_2_] Jennifer[_2_] is offline

external usenet poster

Posts: 24

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 Loses Formatting	ecellis	Excel Discussion (Misc queries)	2	May 5th 09 02:32 PM
Formatting in Excel 2007	Griffen	Excel Discussion (Misc queries)	1	November 11th 08 08:36 AM
Formatting in Excel 2007	IVCC	Excel Discussion (Misc queries)	0	June 10th 08 02:54 PM
Formatting in Excel 2007	pcor	New Users to Excel	3	November 21st 07 03:32 AM
Excel 2007 Formatting	Sue T	Excel Discussion (Misc queries)	7	July 31st 07 10:00 PM

All times are GMT +1. The time now is 07:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us