Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
9 years ago
Solved

PowerQuery: Replace Value (Dashes)

Hi Again,   I'm trying to replace a value - a DASH particularly. It works, however it also does remove the dash symbol for negative numbers. How do I prevent M from doing that?
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi ovetteabejuela,

     

    Is the negative number part of a longer peice of text? 

     

    Could you create a custom column to preserve the negative number before cleaning your original column?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Transform the number to text and replace the dash "-" with "-0". After this convert the column to a number. The "-0" will be converted to 0 and all other numbers will remain the same, since adding a "0" in front of a number will not affect the value of it.