Microft Excel doubts

  1. sid_candid profile image61
    sid_candidposted 5 years ago

    I have to do some calculations on excel but am getting an error as one of my rows which has dollar values is not properly aligned. There is a space between the dollar sign and the number meaning $ 5 whereas I need it without space like $5. I have over 700 cells where I need to do this. I know I can do this manually but can it be done more quickly within a few seconds or so.

    Edit: Title should be Microsoft Excel doubt

    1. prairieprincess profile image96
      prairieprincessposted 5 years ago in reply to this

      Change the number formatting to the Accounting Format. There will be a drop down menu in the numbers group on your Ribbon.

    2. greencap profile image60
      greencapposted 5 years ago

      If its an actual space between $ and the following figure, then do this:

      hit ctrl + H

      in the find what dialog, enter $ sign followed by space

      in the replace with dialog, only enter $ sign

      click the replace all button