hello the community.
when i past negative values from HTML file into excel , the sign equal comes automatically.
So I did Ctrl F , select the column and removed it.
the result is that it turn the negative value in positive value,
any Idea how to keep it negative?
thank you in advance.
Hello Ludo12 and Welcome to Excel Forum.
I don't see any columns that are populated by values preceded by an equal sign. The only columns that I can find which contain an equal sign are those with the FV function. Please inform us of which column you speak.
If the column in the uploaded file has already undergone transformation via the Find and Replace feature then please upload a sample as it would appear when the value is first pasted into Excel.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks