Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to data
I'm importing a text file into Excel 2003 and by using the text to data
facility I'm almost able to create a 'financial' spreadsheet. The problem is that there is a column that contains entries that are credits and appear like 1062.22cr I want the figure to be a true number but cannot find a way to format the column. I'm not bothered whether it appears as -1062.22 or 1062.22- or even 1062.22. I just need to have it have the ability to recognise the numbers and to calculate. To have it recognised as a credit would be preferable so that the column could be used in conjunction with the debit col to have a running balance. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text data with irregular data separators | Excel Discussion (Misc queries) | |||
Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
TEXT and Data converted to only data | Excel Discussion (Misc queries) | |||
Split text without using data-text to columns | Excel Discussion (Misc queries) | |||
How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) |