Microft Excel doubts

  1. sid_candid profile image60
    sid_candidposted 6 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 image95
      prairieprincessposted 6 years agoin 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 6 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