Number as text

[#1]

Hi,

I have a few tables representing month as numbers 0, 1, 2 ... to 12. I no want to change the display of these numbers to text; Jan, Feb, March ... and so on. How do I do this?

Cheers,

Nils

[Anonymous]

A quick and dirty way to solve this is to multiply your month field with 30 and use the function Month where you want it to be displayed as text.

=Month([Month field]*30)

[#3]

thanks bill, but that still doesnt make the numbers go away, which is really what i need. i need the text to replace the numbers, not add to them .

[#4]

tnx, but this again doesnt solve the problem - i still have the numbers showing

[Anonymous]

Nils

It sure works for me, can you advise what kind of object you are using to show the month and the expression used..

Best Regards,     Bill

[Anonymous]

Peter

That, as you say, certainly is dirty, but it does work even though I doubted it would.

I presume it works because date(1) is 31st Dec 1899.

Best Regards,     Bill

[#7]

i am using a list box to show the months. this is also where i try to add the expression

[rustyfishbones]

did you try

[Anonymous]

and could you share the expression ......................

[Anonymous]

and make sure on the Number tab you have not overridden the Default expression............

or set it to Date format of MMM.

[saumyashah90]

In Script

You can do

Table1:

Load * Inline [

MonthNo

1

2

3

4

5

6

7

8

9

10

11

12

];

Table2:

Load Month(MakeDate(2013,MonthNo)) as Months resident Table1;

Drop table Table1;

OutPut:

Months

Jan

Feb

Mar

Apr

May

June

etc