Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to format the numbers in a DataTable of a Chart

Status
Not open for further replies.
feipezi

feipezi

IS-IT--Management
Aug 10, 2006
316
US
Hi,

Hope I made myself clear on the subject. If not, what I need is to format the numbers in a Chart DataTable. I have 2 types of numbers, for now, to put format like "0.00" and "0.0%", using one or more than one Macro. But what I have on the DataTable is like "1.012345" or "0.012345". They are understandable but not so presentable. What I need is like "1.01" and "1.23%".

I tried a few ways of doing it but either got errors or not working. I googled around but it looks like not an easy task.

Thanks in advance.

 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
442
sal21
sal21
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
339
Andrzejek
Andrzejek
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
570
combo
combo
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
900
dhookom
dhookom
Andrzejek
  • Question
Hyperlinks in Word cut at #
Replies
2
Views
172
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top