paliman
Active Member
- Joined
- Jul 7, 2002
- Messages
- 255
Hi all. Here's my problem.
I need to type lots of invoices numbers in order to generate a tax report. Due to requirements of our tax administration department, they should be formatted as ####-########
Most of the times, only the last digit before the "-" and the last 3 or 4 digits will have a value while the rest will be zeros.Something like:
0001-00000123
0001-00004563
0000-00000650
Obviously, I'd like to just type 1-123; 1-4563 and 0-650
If I had to do it in access, I would simply aply a mask to the field. Is there a way to make this in excel? Any ideas?
Adding an extra column and using a formula perhaps?
I need to type lots of invoices numbers in order to generate a tax report. Due to requirements of our tax administration department, they should be formatted as ####-########
Most of the times, only the last digit before the "-" and the last 3 or 4 digits will have a value while the rest will be zeros.Something like:
0001-00000123
0001-00004563
0000-00000650
Obviously, I'd like to just type 1-123; 1-4563 and 0-650
If I had to do it in access, I would simply aply a mask to the field. Is there a way to make this in excel? Any ideas?
Adding an extra column and using a formula perhaps?
