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

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

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

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

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

Thanks, Dave. I just remember that there is a better way to do it. I can save some keystrokes by using the \ instead of ""

####\.##\.####

My interpretation of the OP's request is as follows:-

Currently the periods shown are the result of typing/keying. He/she wants to get rid of them first and then use custom formatting to insert the periods.

...... I am not understanding a simple question!

It's a guessing game and it has nothing to do with comprehension. <G The OP may want something totally different from what I think. We'll never find out unless he/she gives us some feedback.

Epinn

"Dave F" wrote in message ...
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