Epinn--yes, if you want to use the custom format you suggest, that would
work. However, my understanding of the OP's question was that he wanted to
eliminate the periods, not include them.

Perhaps I'm just very dense and I am not understanding a simple question!

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Epinn" wrote:

Dave,

I don't understand the second question.

A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

Totally agree.

once I enter new tariffs have the column formatted (line you can social
security or phone numbers)

Let me guess. Does the OP mean to say

once I enter new tariffs have the column formatted (like (instead of line) you can *with* social
security or phone numbers)

For my learning purpose, I use custom format ####"."##"."####

I keyed in the digits without the periods and the format took place automatically.

Yes, we can use formatcellsnumberspecial for social security or phone numbers but *not* for tariff (codes).

Dave, if there is a better way than my suggested solution, please let me know.

Epinn

"Dave F" wrote in message ...
Periods are the dots in the number sequence the OP gives.

As to removing them, =REPLACE(A1,".","") will eliminate them.

I don't understand the second question.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Mujeeb ur Rehman, FBL-GRW-PK" wrote:

Lonnie,

Can you please explain What is Period???

Mujeeb

"Lonnie" wrote:

I have a spreadsheet with tariff numbers in a column already in the following
format: 9018.90.8000 and I want to be able to:

1. eliminate the "periods" in the current column
2. once I enter new tariffs have the column formatted (line you can social
security or phone numbers)

Can anyone help me...please.

Lonnie