Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know how to import and convert a signed over-punch text into
Excel? I received a text file and its format includes signed over-punch chaharacters, e.g. 0025{ = 2.50, also how do I tell Excel about implied decimal. It can be either part of a vba language or function link for convertion, preferably both. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Importing data to excel (newline/carriage return issue) | Excel Discussion (Misc queries) | |||
Importing parts of a text file into Excel | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Importing text files into Excel | Excel Discussion (Misc queries) |