Solved

# Eccel - Unusual number format

Posted on 2015-01-17
94 Views

http://screencast.com/t/XaEhSd203

I am trying to get a cell to display a number in this format.  Specifically, I want the dollar sign separated from the actual number by a small gap.  As per link.

I have been asked to do this by a client - I am not sure of the logic!
0
Question by:Patrick O'Dea
• 2
• 2

LVL 90

Accepted Solution

John Hurst earned 350 total points
ID: 40555460
The dollar sign either accompanies the number (Currency) or goes to the left side of the cell (Accounting). Try Accounting Format and see it that does what you want.
0

LVL 11

Assisted Solution

Wilder1626 earned 150 total points
ID: 40555469
Can you apply the custom format of your cell to:
``````_-\$* #,##0.00_-;-\$* #,##0.00_-;_-\$* "-"??_-;_-@_-
``````

See if this will work.

Normally, depending on your cell width, you should, by default, get you dollar sign the way you want it.
0

Author Closing Comment

ID: 40555478
Thanks folks,
Both solutions work.

The "Accounting" option is the simpler one.
0

LVL 90

Expert Comment

ID: 40555480
@21Dewsbury  - You are very welcome and I was happy to help.
0

LVL 11

Expert Comment

ID: 40555481
I was also happy to help :-)
0

## Featured Post

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.