Forum Discussion
DataFormat.Error: we couldn't convert to Number
Dears, i was looking to replace( '- ) with ( - ) since in my Excel sheet i have some values with '-70000. the dash caused a problem. when trying to replace it in power query it doesn't allow me ...
Hi Zakaria_1980
Can you create a sample and past it as a table into the body of the post, with both examples?
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hello,
this is the example you have requested. so in case the cell is written with '- it will be just - and delete (') to be converted into number which is below 0. and for date , i want to be displayed as 06/07/2020.
| Value | Date |
| '-770000 | 20200705 |
Thanks in advance.