Format a single digit like "007"?

  • Thread starter Thread starter mezzanine1974
  • Start date Start date
M

mezzanine1974

In the query result, I need to see (for example) a single digit number
(say that "7") as "007".
What is the function for this? I use FormatNumber function for other
purposes.
Can you help me please?
 

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

Named Format equivalent to the FormatNumber function 2
Looking for a 13A plug-in Digital Timer to switch on at dusk . . . 9
VBA code does not copy and paste to next row for each zip code 5
Number displayed as text difficulties 4
RowNum using Numbers 2 Roman code 6
FormCode - Converting Type-E UPC to Type-A (barcodes) 2
presence/absense matrix 4
generate a sequence of random numbers 1

Back
Top