Using "fixed" decimal place function data for charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
 
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.

I'm not familiar with a "fixed function". If it's someone's user defined function
that converts the number to text and trims it to so many characters, that someone is
playing a cruel trick.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top