+ Reply to Thread
Results 1 to 10 of 10

How to keep spaces between $ and other digits in cell entries?

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    How to keep spaces between $ and other digits in cell entries?

    Hi Excel Forum,

    The value of the last cell in the attached looks like this:
    $0.00

    But I wanted to make it look like:
    $ 0.0

    I have been trying to keep spaces between $ and 0.0 but unsuccessful.

    Could anyone help me.

    Thanks

    Mirisage
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: How to keep spaces between $ and other digits in cell entries?

    Select the cells you want to apply formatting, hit Ctrl + F1, under Number tab > Custom , enter

    $ #,##0.0;($ #,##0.0)
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi JieJenn,

    Thank you very much. Your method worked very well.

    Best regards

    Mirisage

  4. #4
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi Mirisage,

    Here's an alternative - see attached.

    Regards

    peterrc
    Attached Files Attached Files

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: How to keep spaces between $ and other digits in cell entries?

    Also you can try this.
    Simple type in cell $0.00 after that click on format - format cell - custom & in type column mentioned below
    $" "0.00
    Last edited by avk; 08-17-2013 at 03:31 PM. Reason: reply

  6. #6
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi Peterrc,
    Thanks.
    However, it is difficult to understand what is the alternative method you have suggested just by looking at what you have attahced.
    If possible, please elaborate how you have done it.
    Thanks

    Hi avk,
    Thanks. Your method worked.
    Regards
    Mirisage

  7. #7
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi Mirisage,

    Sorry for the late reply - I didn't receive an e-mail notification of your reply.
    All I have done is put the cursor between the $ and the 0.00 (in the Type and press enter twice (for 2 spaces) to achiece $ 0.00.
    Please see attached.

    Regards

    peterrc
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi Mirisage,

    OOPS!

    I pressed the space bar twice NOT enter twice.
    (Incidentally, I have no idea how the "smiley" got there.

    Regards

    peterrc

  9. #9
    Forum Contributor
    Join Date
    12-14-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    104

    Re: How to keep spaces between $ and other digits in cell entries?

    Hi peterrc,

    Apologies for the belated reply.

    Thank you for your inputs.
    Mirisage

  10. #10
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: How to keep spaces between $ and other digits in cell entries?

    With Windows Seven you can also go to the Control Panel and check the format of currency in tab "Country and Language" / "Additional Settings" and choose to have a space between simbol and first digit. Excel will follow.
    Last edited by rollis13; 09-03-2013 at 05:39 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-02-2011, 03:08 AM
  2. Replies: 5
    Last Post: 12-08-2008, 11:47 AM
  3. Replies: 4
    Last Post: 03-07-2008, 05:21 PM
  4. How can I ensure entries in a column are 16 chars long using spaces?
    By compact in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2007, 06:11 AM
  5. Putting spaces every few digits
    By sheargraphix in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-25-2007, 03:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1