Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Sum, how do you turn it off?? | Excel Worksheet Functions | |||
turn off auto fill down | Excel Discussion (Misc queries) | |||
how do i turn off auto fill? | Excel Discussion (Misc queries) | |||
turn off auto subtotal | Excel Worksheet Functions | |||
How do I turn off auto correct? | Excel Discussion (Misc queries) |