'Data extracted from Excel is different than the one in database. It's appearing as "=-" in Excel but "-" in database table
As per title. Not sure what to do to extract the correct data format.
Screenshots:
Solution 1:[1]
If you are copy pasting to Excel, first format the column as text and then try to paste the data. You can use the Data->Get Data->From Database in Excel to directly extract the table data from database and the columns will be formatted automatically.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Dale K |