| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trailing minus
hi
while importing a txt file into xl there is one column which is in txt format having figures with trailing minus (ex: 100-, 150-,100000-). how can i change them into real numbers for arithmetical operations??? added to the head ache is that the column is aligned horizontally centred!!! any hlp pl?! -via135 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
| Trailing Graphs | Excel Discussion (Misc queries) | |||
| .xls trailing on end of name for workbook | Excel Discussion (Misc queries) | |||
| Trailing blanks | Excel Discussion (Misc queries) | |||
| Importing values w/trailing minus signs | Excel Discussion (Misc queries) | |||
Threaded Mode
