Add a digit in a number

G

Guest

Hello, in table1 I have a field: tel1
That field has telephone numbers entered. I want the number "0" entered
right after the 4th number of every entry. For example, if 123456789 is
entered, I want it to become 1234056789. So 0 (zero) is entered after the 4th
digit.
Can someone help me please?

Thank you
Dimitris
 
G

Guest

Thank you Peter, it worked fine.

Pieter Wijnen said:
Left([Field],4) &"0" & Mid([Field],5)

Pieter

Dimitris said:
Hello, in table1 I have a field: tel1
That field has telephone numbers entered. I want the number "0" entered
right after the 4th number of every entry. For example, if 123456789 is
entered, I want it to become 1234056789. So 0 (zero) is entered after the
4th
digit.
Can someone help me please?

Thank you
Dimitris
Click to expand...
Click to expand...
 

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

Two questions 7
Changing the format of data 6
Enter a dot between numbers 1
Changing numbers 2
Filter asterisks from a field 2
Specific filter for the data in a field 1
Moving the last numbers of a field 3
Moving the last numbers of a field 3

Top