| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells format
Doesn't work in Excel 2000 or Excel 97 at least. (as far as reevaluating
the cells. If you meant to separate the number from the negative sign, that would be different). -- Regards, Tom Ogilvy "Frank Kabel" wrote in message ... Hi try using 'Data - Text to columns' to convert the negative numbers to rela values -----Original Message----- Hi. I have a problem. When I import a .txt file create by an accounting software, where there are negative numbers value in this format (for example 150-), after the importation those numbers have a text format and I can't sum them with the other numbers. I have a custom format (#.##0;#.##0-) but I can't apply it after the importation. Can you help me? --- Message posted from http://www.ExcelForum.com/ . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 format cells to date format | Excel Discussion (Misc queries) | |||
| How to format cells in Excel 2007 (i.e. currency format)? | Excel Discussion (Misc queries) | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| Cells won't convert to number format, even after format/cells/num. | Excel Discussion (Misc queries) | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Threaded Mode
