Hi Charlie,

I tried to look for disabling this however not much luck, but there is a way
around this. If you enter 10 A as '10 A, Excel will not change it.

I will keep looking for the solution and let you know ASA I get one.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Charlie" wrote:

Hi,

We are creating Excel reports for electrical equipment rated power (Amps),
e.g.

Equip Equip
Rated Full
Power Load
------- ------
25 HP 60 A
30 HP 100 A
5 HP 10:00 AM

As you can see, Excel automatically converted "10 A" to 10:00 AM, assuming
the input was a time abbreviation. Without me going through all of our
report templates and forcing the cell formats to "Text", is there an
application setting to tell Excel not to auto-convert my input values?

TIA,
Charlie