How can I insert a period into exsisting cells?
 

Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM

How can I insert a period into exsisting cells?
 

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM

How can I insert a period into exsisting cells?
 

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM


"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM

How can I insert a period into exsisting cells?
 

=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

How can I insert a period into exsisting cells?
 

Than you very much! It worked perfectly!

I appreciate your all you help.

JM

"Dave Peterson" wrote:

=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

How can I insert a period into exsisting cells?
 

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" wrote in message
...
=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after
the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string
of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do
this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

How can I insert a period into exsisting cells?
 

But watch out for things like:
26260G



Peo Sjoblom wrote:

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)

"Dave Peterson" wrote in message
...
=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be inserted
after the first 2 digits. I need to insert the period after the first 2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after
the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a string
of
numbers? I have 800 numbers I need to change in A1 to A801. Can I do
this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

--

Dave Peterson

How can I insert a period into exsisting cells?
 

Doh!

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" wrote in message
...
But watch out for things like:
26260G



Peo Sjoblom wrote:

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)

"Dave Peterson" wrote in message
...
=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be
inserted
after the first 2 digits. I need to insert the period after the first
2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after
the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a
string
of
numbers? I have 800 numbers I need to change in A1 to A801. Can I
do
this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

--

Dave Peterson

How can I insert a period into exsisting cells?
 

Oops Forgot the formula

=SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)&".",1)

--
Regards,

Peo Sjoblom

(No private emails please)


"Dave Peterson" wrote in message
...
But watch out for things like:
26260G



Peo Sjoblom wrote:

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)

"Dave Peterson" wrote in message
...
=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be
inserted
after the first 2 digits. I need to insert the period after the first
2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after
the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a
string
of
numbers? I have 800 numbers I need to change in A1 to A801. Can I
do
this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

--

Dave Peterson

How can I insert a period into exsisting cells?
 

Ok!

Peo Sjoblom wrote:

Oops Forgot the formula

=SUBSTITUTE(A3,LEFT(A3,2),LEFT(A3,2)&".",1)

--
Regards,

Peo Sjoblom

(No private emails please)

"Dave Peterson" wrote in message
...
But watch out for things like:
26260G



Peo Sjoblom wrote:

Another way

=SUBSTITUTE(A1,LEFT(A1,2),LEFT(A1,2)&".")

--
Regards,

Peo Sjoblom

(No private emails please)

"Dave Peterson" wrote in message
...
=left(a1,2)&"."&mid(a1,3,255)



JM wrote:

Sorry I should have made it clear. Yes the it will be always be
inserted
after the first 2 digits. I need to insert the period after the first
2
digtis.

26150G to 26.150G
33207G to 33.207G
03273G to 03.273G
05069G to 05.069G and so on.

Thanks

JM

"Peo Sjoblom" wrote:

What's the rule where to insert it, will it always be inserted after
the 2
character like in 23.150G or what would the rule be?

--
Regards,

Peo Sjoblom

(No private emails please)


"JM" wrote in message
...
Hello, Is it possible to insert a period into the middle of a
string
of
numbers? I have 800 numbers I need to change in A1 to A801. Can I
do
this
without having to retype the entire column?

Here's an example:
I need to change 26150G to 26.150G

Any help will be greatly appreciated.
Thank You

JM




--

Dave Peterson

--

Dave Peterson

--

Dave Peterson