Numbers to Text

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

I need to covert numbers to text in a field this is easily
done in excel but i am trying to shorten the procedure.

curretnly in excel the formula is =TEXT(cell
ref,"00000.00")
this gives me my number in text format but is the function
text supported in access ?

Robbie
 
Use the format function. Format(value, "00000.00")

--
HTH

Dale Fye


I need to covert numbers to text in a field this is easily
done in excel but i am trying to shorten the procedure.

curretnly in excel the formula is =TEXT(cell
ref,"00000.00")
this gives me my number in text format but is the function
text supported in access ?

Robbie
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Excel Change Excel Text colour from Formula Bar 0
Format Currency field into zero filled text field 1
changing a number to text 1
text to number 1
Changing Text To Numbers ? 1
Convert Text to number 8
Sum number range ignoring numbers formatted as text 0
How to subtract a number from a Mergefield? 0

Back
Top