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
 
Back
Top