Numbers to Text

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
 
D

Dale Fye

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
 

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

Formating bolded text exclusively. 0
Excel does not accept text format! 0
Finding the proper style field and the numbered paragraph value within the style 0
How can the font and size of (all) citation numbers be altered? 1
Link a text box based on drop down box with four options MS Word 365 0
Inconsistent formatting of section numbers 0
Paste to excel from word - auto format problem 1
Page numbering with Merged Document and IF statements 1

Top