Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2008
    Location
    Daytona Beach, Florida, USA
    Posts
    42
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Can you change a number to the text of the number? Say 2 to TWO. This would be for [No of Tickets] in the following:

    ="Bearer is entitled " & [No of Tickets] & " complimentary seats for the " & [Type of Ticket] & " at Daytona International Speedway on " & Format([Date of Event],"Long Date") & "."]

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Here is a Microsoft Article about how to do this. The article talks about currency, but the ideas should still apply.
    Regards
    John



  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    If there are not a large number of ticket number options, then you could also just use a simple lookup
    with a 2 column table
    Column 1 is number, column Primary Key, Column 2 is spelling.
    Then use a dlookup or query to get the spelling from the number


    Code:
    Num         Spelling
    -----------------------
    1           One
    2           Two
    3           Three
    etc
    But no good if there are hundreds or even thousands.
    Andrew

Posting Permissions

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