Data Table Numeric Formatting

's Computer Specifications

I need to format the data displayed in a data table I created for a chart. The X values line of the data table is displaying some numerics using 0.00004 format, while others are using 5E-5 formatting. I would like them all to be the same (ie. 0.00005). Please help. Thank yo
Tom

's Computer Specifications

The Data Table feature has limited capability. For a workaround see
the Excel/Tutorials/Custom Chart Table page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <AA96DCFD-2CDC-4251-8F21-(E-Mail Removed)>,
(E-Mail Removed) says...
> I need to format the data displayed in a data table I created for a chart. The X values line of the data table is displaying some numerics using 0.00004 format, while others are using 5E-5 formatting. I would like them all to be the same (ie. 0.00005). Please help. Thank you
> Tom
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditionally formatting numeric data and text differently	Albannach	Microsoft Excel Worksheet Functions	1	20th Jan 2010 02:18 AM
Formatting numeric data in textbox	Andrus	Microsoft C# .NET	13	14th Jun 2008 06:34 AM
External Data-Changing Numeric Formatting	=?Utf-8?B?Q2hlcnls?=	Microsoft Excel Programming	2	20th Apr 2007 02:06 PM
Alignment of numeric data in a table column	carol	Microsoft Access Getting Started	1	2nd Jul 2004 10:14 PM
Data Field in Pivot Table is Non-numeric	=?Utf-8?B?Ui4gVmVudQ==?=	Microsoft Excel Misc	5	17th Jan 2004 02:12 AM