Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have some cells labeled as euros and some as dollars.

For some reason the dollar sign is left-justified with a space between it and the value.

The cell is right justified.

How can I get the dollar-formatted currency cell to appear correctly, i.e. on right without the space between dollar sign and value?

enter image description here

share|improve this question
1  
The answer depends on if the underlying value in the cell is a number with cell formatting doing the presentation? Or is the cell value a string as shown in your image? –  chris neilsen Oct 7 '11 at 23:05
add comment

3 Answers

Are you using the "currency" cell format, or the "accounting" cell format? I've found that "accounting" puts the dollar sign way over to the left, while "currency" puts it against the numbers. I've also found that clicking the dollar sign in the toolbar applies "accounting" which is never what I want because I'm not an accountant.

Looks like when choosing the euro symbol you get the choice of putting it before or after the number, and you chose to put it after. If you chose to put it before, you'd get the same display with the symbol way over to the left.

share|improve this answer
add comment

This question has been asked elsewhere and the answer has generally required some vba code.

Option Explicit 

Public Function SUMCURRENCY(rgSumArea As Range) As Long 
    Dim rgCell As Range 

    For Each rgCell In rgSumArea 
        SUMCURRENCY = SUMCURRENCY + Strings.Mid(rgCell.Value, 2) 
    Next rgCell 
End Function 

Or you could play around with the Custom cell format. Here's instructions on the syntax necessary for custom formatting. A problem with this solution would be if you have multiple forms of currency in a column or row.

share|improve this answer
add comment

I hope I understood your question right.

You can try this:

  1. Go to Cell Styles.
  2. Right-click Currency. Click Modify.
  3. Click Format.
  4. Click Custom and then enter the format:

    #,##0.00 $

  5. Click OK.

Whenever you click the Currency format button on the toolbar, it should use the format/style you set up.

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.