+ Reply to Thread
Results 1 to 5 of 5

Help with .NumberFormat

  1. #1
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Help with .NumberFormat

    Can you please explain or provide a link to info about the .NumberFormat parameter?

    I am using:

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    but I also need to set a cell to "text" (in Excel, the command is Format, Cells, Number, Text)

    and another cell to 3 decimal places ...

    Thanks for helping me.
    Last edited by proepert; 01-18-2010 at 06:54 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Help with .NumberFormat

    For text

    Please Login or Register  to view this content.
    For Decimals

    Please Login or Register  to view this content.
    if in doubt - use the macro recorder and review...

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help with .NumberFormat

    Hi,
    Please Login or Register  to view this content.
    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Re: Help with .NumberFormat

    Quote Originally Posted by DonkeyOte View Post
    if in doubt - use the macro recorder and review...
    Thanks, this will reduce me post count and I can learn myself.

  5. #5
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Re: Help with .NumberFormat

    Thanks to all, you are all so very helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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