| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells format
Hi.
I have a problem. When I import a .txt file create by an accountin software, where there are negative numbers value in this format (fo example 150-), after the importation those numbers have a text forma and I can't sum them with the other numbers. I have a custom forma (#.##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
