Turn off Auto-Converting entries
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
|