Solved

Eccel - Unusual number format

Posted on 2015-01-17
5
95 Views
Last Modified: 2015-01-17
See this link

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
Comment
Question by:Patrick O'Dea
  • 2
  • 2
5 Comments
 
LVL 92

Accepted Solution

by:
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

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

Open in new window


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

by:Patrick O'Dea
ID: 40555478
Thanks folks,
Both solutions work.

The "Accounting" option is the simpler one.
0
 
LVL 92

Expert Comment

by:John Hurst
ID: 40555480
@21Dewsbury  - You are very welcome and I was happy to help.
0
 
LVL 11

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Generating a graph via Excel 3 27
Problem to With line 4 43
Excel 2016 - Black cell borders 11 27
How do i remove text in between commas in Excel? 14 18
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
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 a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now