Re: Preceding Zero's

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can change the format of these cells in the spreadsheet to Text.
Bear in mind this will not sort correctly in numerical order so you
will need to make sure the line items are in the right order before
creating your chart.

Wigi wrote:
Try custom formatting your axis values.

Double click a value on the axis, and format it accordingly as you would
normally do in Excel itself.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"s. Dost" wrote:

I have a chart with the x-axis labeled: 1000-2000, 10000-11000, 19000-20000,
2000-3000. Do you have any ideas on how to hold onto the preceding zeros so
it will list right?
.

Relevant Pages

  • Re: Vista Application Icon
    ... fixes the problem. ... Bear in mind that the new 256x256 format is really an embedded PNG file, ...
    (borland.public.delphi.non-technical)
  • RE: replacing carriage returns with HTML break tags
    ... based on the code that I'm working can I use the Replace method with Format ... Bear in mind that the MSDN .Net documentation is nothing but gibberish to me. ... >> I'm changing our order confimation from a plain text to HTML. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Annotated report template
    ... "Bear" wrote: ... and are completely replaced when the user starts typing. ... you select it and click Format> Font. ...
    (microsoft.public.word.docmanagement)
  • Re: 5x5s?
    ... The 5x5 format gives me the same round cigars ... >Nothing cosmetically inferior about those little beauties. ... "Be who you are and say what you feel, because those who mind don't matter, ...
    (alt.smokers.cigars)
  • Re: Small question?
    ... I shall keep it uppermost in my mind about dates ... If I have read it well, than DateString returns forever a MM dd yy format. ... Dim mylogfiledate As String = Now.ToString ...
    (microsoft.public.dotnet.languages.vb)