View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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