Excel keeps converting my %s to Time format

Thanks Dave,

That seems like it should work but I'd like to avoid it if possible.

I have almost 1000 such cells, each with their own format and I'd like
to be able have some flexibility without having the formats centrally
managed like that. I.e. if someone wants a number formatted
differently, they should be able to change it in the cell properties
without having to get involved with VBA.

Why can't Excel just leave the formats alone? It drives me nuts that I
can't type "1-3" without it converting it to Jan-3. Surely there must
be a way to turn off this 'feature'!

I've seen excel change formats from General to Date (or Time), but I've never
seen it change from Percent to time.

The way I turn the feature off for 1-3 becoming Jan-3 is to format the cell as
text (or add that leading apostrophe (both of which you don't like...)

Michael Deathya wrote:
>
> Thanks Dave,
>
> That seems like it should work but I'd like to avoid it if possible.
>
> I have almost 1000 such cells, each with their own format and I'd like
> to be able have some flexibility without having the formats centrally
> managed like that. I.e. if someone wants a number formatted
> differently, they should be able to change it in the cell properties
> without having to get involved with VBA.
>
> Why can't Excel just leave the formats alone? It drives me nuts that I
> can't type "1-3" without it converting it to Jan-3. Surely there must
> be a way to turn off this 'feature'!

--

Dave Peterson