Using format()

  • Thread starter Thread starter Rodolfo Fontes
  • Start date Start date
R

Rodolfo Fontes

Hi group,

How can I set a number to be like this?
Original: 123456
Result: 000012345600

Thanks,
Rodolfo Fontes
 
Off the immediate window

? format("123456", "0000000000") & "00"
000012345600
? format("000456", "0000000000") & "00"
000000045600
? format("120456", "0000000000") & "00"
000012045600

Krgrds,
Perry
 

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

How to verify if a Form is open 3
Error 2105 1
formating currency to number 2
Erros list 1
too few parameters 2 5
Setting last number on a Table. 4
Excel Create a New line in a Word Link without double "" around result 0
EAN 13 5

Back
Top