I have a file that was downloaded into text format. I used the value function to convert the positive numbers. The negative numbers look like this
1234.56- How can I convert this into a negative value?
I have a file that was downloaded into text format. I used the value function to convert the positive numbers. The negative numbers look like this
1234.56- How can I convert this into a negative value?
Last edited by VBA Noob; 06-06-2008 at 12:54 PM.
Try this.where A1 is the cell with your text.Please Login or Register to view this content.
ChemistB
It worked!
Good deal!
incognito, please start your own thread.
Entia non sunt multiplicanda sine necessitate
Scorpvin, after clearing the non-breaking spaces, do Text to columns on each column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks