Problem with month format

Originally Posted by berlan

if you want the result as a text string, one way is to add the prefix '

Please Login or Register  to view this content.

Well I actually dont want that prefix.

I actually solved by:

Please Login or Register  to view this content.

cheers

Do you want it as a text string, otherwise change the number formatting?

Please Login or Register  to view this content.

without changing the content.

or,

Please Login or Register  to view this content.

changing the number formatting to recognize it as text. and fyi, a prefix character wouldn't the change the effect when comparing to other data, as you can see with the example below:

Please Login or Register  to view this content.