software

I have created a histogram and would like to label the bin range with number
ranges, e.g. 0-4, 5-9, 10-14, 15-19 etc. This works fine for 0-4 and 15-19
upwards, but 5-9 is always interpretted by Excel as 05-Sep and 10-14 as
10-Oct! I cannot stop this happening. I have tried removing the cell format
but to no avail, it will not allow these number ranges without changing the
format to a date.

I can input a single number without problems by changing the cell format to
general, but whenever I try to input 5-9, I always get 05-Sep!

Any ideas?

precede entry with apostrophe '--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Paulquot; gt; wrote in message
...
gt;I have created a histogram and would like to label the bin range with
gt;number
gt; ranges, e.g. 0-4, 5-9, 10-14, 15-19 etc. This works fine for 0-4 and
gt; 15-19
gt; upwards, but 5-9 is always interpretted by Excel as 05-Sep and 10-14 as
gt; 10-Oct! I cannot stop this happening. I have tried removing the cell
gt; format
gt; but to no avail, it will not allow these number ranges without changing
gt; the
gt; format to a date.
gt;
gt; I can input a single number without problems by changing the cell format
gt; to
gt; general, but whenever I try to input 5-9, I always get 05-Sep!
gt;
gt; Any ideas?
Brilliant! Thank you very much. How did you find that out?

quot;Peo Sjoblomquot; wrote:

gt; precede entry with apostrophe '
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Paulquot; gt; wrote in message
gt; ...
gt; gt;I have created a histogram and would like to label the bin range with
gt; gt;number
gt; gt; ranges, e.g. 0-4, 5-9, 10-14, 15-19 etc. This works fine for 0-4 and
gt; gt; 15-19
gt; gt; upwards, but 5-9 is always interpretted by Excel as 05-Sep and 10-14 as
gt; gt; 10-Oct! I cannot stop this happening. I have tried removing the cell
gt; gt; format
gt; gt; but to no avail, it will not allow these number ranges without changing
gt; gt; the
gt; gt; format to a date.
gt; gt;
gt; gt; I can input a single number without problems by changing the cell format
gt; gt; to
gt; gt; general, but whenever I try to input 5-9, I always get 05-Sep!
gt; gt;
gt; gt; Any ideas?
gt;
gt;
gt;