+ Reply to Thread
Results 1 to 2 of 2

When I paste negative values in Excel from HTML, the sign egual appear

  1. #1
    Registered User
    Join Date
    02-28-2020
    Location
    cyprus
    MS-Off Ver
    office 365 pro plus
    Posts
    1

    When I paste negative values in Excel from HTML, the sign egual appear

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,485

    Re: When I paste negative values in Excel from HTML, the sign egual appear

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to prevent users for putting a negative sign in excel
    By dezspert22 in forum Excel General
    Replies: 5
    Last Post: 02-01-2017, 04:42 PM
  2. Replies: 4
    Last Post: 09-22-2015, 12:48 PM
  3. Macro to copy the range of values from Excel and paste in html file
    By harishpeddi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2014, 10:50 AM
  4. To paste negative values in adjacent cells
    By viveksingh222 in forum Excel General
    Replies: 2
    Last Post: 07-20-2013, 04:23 AM
  5. Replies: 1
    Last Post: 04-26-2012, 12:48 AM
  6. Macro to open file, copy paste as values and save as excel html
    By gsav in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-18-2011, 10:15 AM
  7. negative numbers w/o negative sign
    By whtbullitt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-31-2009, 05:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1