Prev: Want to add a dot in between to Names
Next: Insert blank row after change in cell value not working.
From: Kathie on 2 Feb 2010 07:46
I have extracted data from a PDF file into Excel using Able to Extract
program. In the PDF file, negative numbers are stored with the minus at the
end., ie., 12345.00-. I need the numbers to have the minus in the front,
i.e., -12345.00. I cannot get Excel to format for me. Any suggestions?
From: "David Biddulph" groups [at] on 2 Feb 2010 08:03
Data/ Text to columns
--
David Biddulph

"Kathie" <Kathie(a)discussions.microsoft.com> wrote in message
news:455D91BA-9374-4133-847F-AD4DC12DF50C(a)microsoft.com...
>I have extracted data from a PDF file into Excel using Able to Extract
> program. In the PDF file, negative numbers are stored with the minus at
> the
> end., ie., 12345.00-. I need the numbers to have the minus in the front,
> i.e., -12345.00. I cannot get Excel to format for me. Any suggestions?


From: Jacob Skaria on 2 Feb 2010 08:11
Select the cells with the -ve figures..From menu Data>Text to Columns>Hit
'Next' and again 'Next' will take you to Step3 of the Wizard.
Click on Advanced> and make sure 'Trailing minus for negative numbers' is
checked and hit OK>Finished..

--
Jacob


"Kathie" wrote:

> I have extracted data from a PDF file into Excel using Able to Extract
> program. In the PDF file, negative numbers are stored with the minus at the
> end., ie., 12345.00-. I need the numbers to have the minus in the front,
> i.e., -12345.00. I cannot get Excel to format for me. Any suggestions?
 | 
Pages: 1
Prev: Want to add a dot in between to Names
Next: Insert blank row after change in cell value not working.