+ Reply to Thread
Results 1 to 7 of 7

Anchoring Named Cells + Custom Number Formatting

  1. #1
    Registered User
    Join Date
    01-16-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    51

    Anchoring Named Cells + Custom Number Formatting

    Hi Guys

    I have 2 questions I need your assistance on please:

    1) Is it possible to anchor a named cell (see my comment box in attached excel document). Perhaps I could use a certain function like search/find if this is not possible?

    2) I am still having issues with custom number formatting (I have tried in vain numerous different combinations but cannot seem to get it correct - see comment box in excel doc attached). I am looking for a single custom number format that will NOT show the "," in front of the $50,000 (currently it is displaying the above cells correctly but when I copy the number formatting Cell B4 incorrectly displays $,50,000).

    Thanks in advance for any help

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,743

    Re: Anchoring Named Cells + Custom Number Formatting

    Why can't you select
    format cells >numbr>currency under category>$ English(United States) under symbols
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,434

    Re: Anchoring Named Cells + Custom Number Formatting

    1. How about if you only use a range name on No_of_Lots, and not on the other cells?
    =B2/Number_of_Lots
    copied down

    2. all those cells look to have the same appearance/format to me?
    B
    2
    $1,000,000
    3
    $1,250,000
    4
    $,50,000
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    01-16-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    51

    Re: Anchoring Named Cells + Custom Number Formatting

    Hi Fdibbins

    1) Thanks for the tip - I actually did this first and then renamed the cells B2-B4 afterwards using Ctrl + Shift + F3 (and I didn't get an error so all worked out well!).

    2) The Cell B4 has a comma in front of the $50,000 so that was my issue with it, but I sorted it out though thanks!

    Regards

    SilverBullet17

  5. #5
    Registered User
    Join Date
    01-16-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    51

    Re: Anchoring Named Cells + Custom Number Formatting

    Hi Siva

    This was one of my first thoughts but when I tried this I didn't have the comma. I have subsequently changed my entire settings to US (rather than South African which I had before) and the original custom number format now seems to work perfectly - appreciate your input though!

    Regards

    SilverBullet17

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,434

    Re: Anchoring Named Cells + Custom Number Formatting

    Im happy you got this resolved

    Hoe gaan dit daar in die kaap?
    ex PE and Klerksdorp old boy here, now living in USA

  7. #7
    Registered User
    Join Date
    01-16-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    51

    Re: Anchoring Named Cells + Custom Number Formatting

    Ya lekker dankie en self? (Not sure how good your Afrikaans is :p)

    Funnily enough I was actually in Klerksdorp a couple month ago (there's a helluva lot of development going on for such a small town). How long have you been in the states? I'm moving to the East Coast in 6 months time on a study visa so looking forward to it - how has your experience been?

+ 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. Custom Number formatting
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2015, 11:32 AM
  2. VBA Custom Number Formatting
    By btone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-24-2015, 11:40 AM
  3. [SOLVED] Custom Number Formatting
    By zanshin777 in forum Excel General
    Replies: 9
    Last Post: 05-13-2015, 03:24 PM
  4. Custom Number Formatting
    By springboardjg in forum Excel General
    Replies: 1
    Last Post: 07-01-2012, 01:23 PM
  5. Custom number formatting
    By Don in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2006, 09:40 AM
  6. Number custom formatting
    By Don in forum Excel General
    Replies: 1
    Last Post: 06-24-2006, 10:40 PM
  7. Custom Number Formatting
    By CSBUG in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 04:50 PM

Tags for this Thread

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