| |

VerySource

 Forgot password?
 Register
Search
View: 1047|Reply: 9

Is there any way to turn "1" into ‘one’?

[Copy link]

4

Threads

7

Posts

7.00

Credits

Newbie

Rank: 1

Credits
7.00

 China

Post time: 2020-2-1 22:20:01
| Show all posts |Read mode
I am going to convert 12 months into one or two. . . Is there any way to do it, can it only be written hard (write the judgment statement by yourself)?
Reply

Use magic Report

0

Threads

2

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-3-6 12:16:42
| Show all posts
i = month (date) gets the current date and month
select case i
    case 1
       msgbox "one"
    case 2
       msgbox "two"
    case 3
       msgbox "three"
    case 4
       msgbox "four"
    case 5
       msgbox "five"
    case 6
       msgbox "six"
    case 7
       msgbox "seven"
    case 8
       msgbox "eight"
    case 9
       msgbox "nine"
    case 10
       msgbox "ten"
    case 11
       msgbox "eleven"
    case 12
       msgbox "twelve"
end select
Reply

Use magic Report

0

Threads

9

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-3-17 12:00:01
| Show all posts
if 1 then one, under?
Reply

Use magic Report

4

Threads

7

Posts

7.00

Credits

Newbie

Rank: 1

Credits
7.00

 China

 Author| Post time: 2020-3-18 12:30:02
| Show all posts
I just asked, is there any way other than this hard-written method?
Reply

Use magic Report

0

Threads

9

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

Post time: 2020-3-19 18:00:02
| Show all posts
I wrote it using someone else, I wrote it myself ^-^
Reply

Use magic Report

0

Threads

9

Posts

8.00

Credits

Newbie

Rank: 1

Credits
8.00

 China

Post time: 2020-3-19 20:00:01
| Show all posts
If you have written it by others, you do n’t have to write it yourself ^-^
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-4-24 19:15:01
| Show all posts
MonthName function
See example features

description

Returns a string representing the specified month.

grammar

MonthName (month [, abbreviate])

MonthName function syntax has the following parts:

Part Description
month required. The numeric value of the month. For example, January is 1, February is 2, and so on.
abbreviate is optional. Boolean value indicating whether the month name is abbreviated. If omitted, the default value is False, indicating that the month name cannot be abbreviated
Reply

Use magic Report

0

Threads

10

Posts

7.00

Credits

Newbie

Rank: 1

Credits
7.00

 China

Post time: 2020-4-26 12:30:01
| Show all posts
dim ms () as string
ms = split ("January, February ... December", ",")

.... = ms (month (now))
Reply

Use magic Report

0

Threads

3

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-8-2 12:30:01
| Show all posts
Define an array
N(0)="zero"
....
N(9)="nine"
Your number is the subscript.
Reply

Use magic Report

1

Threads

2

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-8-3 22:58:43
| Show all posts
Learn, is there a function that can directly convert numbers to Chinese characters?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list