Do you mean you want to convert "123" which is now one of the number
formats into "123" text, possibly so you can change it to "0123" and or sort
it differently. or do you want to change "123" to "one two three"? What
format is it in now, single, double, long etc.?
Generally if it is really a number, it should stay a number in the
database, but you may want to display it as words in reports or forms. If
it is really text, as a part number, or zip code might be, then you should
change the table properties so it is text.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.