Data Table Numeric Formatting

T

Tom J H

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
 
T

Tushar Mehta

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
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
List all tables, including document structure 0
ASK Field Formatting 1
VBA - (re-) Set a Table Style 2
Plotting Graph with dynamic table 3
Format Data Labels Doesn't Save 2
Internal Data Integrity (Type 4) Details Needed 1
VBA code in Excel opens Word template and fills bookmarks, but can't get correct formatting 5

Top