+ Reply to Thread
Results 1 to 6 of 6

Excel Spell Numbers but correct grammar

  1. 01-16-2023, 02:10 AM #1
    dhsjadhsaj
    dhsjadhsaj is offline
    Registered User
    Join Date
    12-18-2022
    Location
    -
    MS-Off Ver
    -
    Posts
    2

    Excel Spell Numbers but correct grammar

    Hi,

    I have modified some code I have found online to spell out a number when typed in. I have altered the code to display the word "and" in the hundreds section (i.e. One Hundred and six and not One Hundred Six). The issue I'm now facing is that If I have 100 as the number it will now display as "One Hundred and", subsequently for the other hundreds too. From my understanding I need to have another case to deal with this but my limited knowledge stops me from fixing it, so any help would be appreciated

    Here's my code i'm working with

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-16-2023, 04:31 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,169

    Re: Excel Spell Numbers but correct grammar

    Please add both your Location and Excel version to your profile as answers depend on knowing this information.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 01-16-2023, 05:19 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: Excel Spell Numbers but correct grammar

    Try
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 01-16-2023, 09:07 PM #4
    dhsjadhsaj
    dhsjadhsaj is offline
    Registered User
    Join Date
    12-18-2022
    Location
    -
    MS-Off Ver
    -
    Posts
    2

    Re: Excel Spell Numbers but correct grammar

    Hi, thanks for reply -- I can't seem to get this function working. Is this to add in another module? or to amend existing code?


    EDIT:

    Have it working,

    only issue being that for a number such as 123,456 it will type One Hundred and Twenty Three Thousand, Four Hundred and Fifty Sixteen -- how would I fix this?
    Last edited by dhsjadhsaj; 01-16-2023 at 09:31 PM.
    Reply With QuoteRegister To Reply
  5. 01-17-2023, 12:42 AM #5
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: Excel Spell Numbers but correct grammar

    What you want to read 123456
    Reply With QuoteRegister To Reply
  6. 01-17-2023, 12:50 AM #6
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,583

    Re: Excel Spell Numbers but correct grammar

    May be this.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. DIY Spell Check Table To Correct Data Errors using VBA
    By edneal2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2017, 09:13 AM
  2. How do I convert week or day numbers into its correct format in words/numbers in Excel?
    By gtz101 in forum Excel General
    Replies: 8
    Last Post: 06-28-2014, 03:26 PM
  3. Spell Check and Grammar check in Particular Column
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 06:35 PM
  4. Spell Numbers Excel
    By rami10 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-28-2013, 02:22 PM
  5. How does Excel spell out numbers in words ?
    By Kat in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 09:35 PM
  6. [SOLVED] Is there a grammar checker for Excel?
    By DDC in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM
  7. How do I spell numbers as words for writing checks in Excel?
    By Heather in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2005, 05:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1