Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can anybody help with a small issue we have?
We run a few reports from a 3rd party UNIX system which export into Excel. These reports contain stock locations, some of which are represented by 1E1. However, when I export these into Excel, they are automatically concerted into the Scientific Category and show as 1.00E+01. My question is this, is there a way to SWITCH OFF this automatic conversion to ensure that my stock locations of 1E1 remain as 1E1? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
cell entries | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |