Add a digit in a number

D

Dimitris

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
 
D

Dimitris

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

Delete all data after a symbol in a field 0
Is this possible? 0
Autonumber field in Excel that behaves the same as Access 0
Two questions 7
Changing the format of data 6
How to correct a #N/A in vlookup 1
Filter asterisks from a field 2
Enter a dot between numbers 1

Top