Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.

Works for me. Perhaps you've got spaces or other invisible characters in
your cell? Have a look at =MID(A15,2,1) to see whether it finds zero. You
say it's not functioning, but you haven't told us what the formula returns.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.

Hello David from Steved

It is giving me a VALUE!

The reason is that I've checked my column and it is formatted as Text
instead off General. Yes I went to another worksheet with column set as
General and it works.

Is it possible for the formula to work in either text or general.

Thankyou.


"David Biddulph" wrote:

Works for me. Perhaps you've got spaces or other invisible characters in
your cell? Have a look at =MID(A15,2,1) to see whether it finds zero. You
say it's not functioning, but you haven't told us what the formula returns.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.

It should work with the cell formatted as text.
What is the value of =MID(A15,2,1)?
Did you look at your cell formatted as text to see whether there are leading
spaces or other invisible characters?
--
David Biddulph

"Steved" wrote in message
...
Hello David from Steved

It is giving me a VALUE!

The reason is that I've checked my column and it is formatted as Text
instead off General. Yes I went to another worksheet with column set as
General and it works.

Is it possible for the formula to work in either text or general.

Thankyou.


"David Biddulph" wrote:

Works for me. Perhaps you've got spaces or other invisible characters in
your cell? Have a look at =MID(A15,2,1) to see whether it finds zero.
You
say it's not functioning, but you haven't told us what the formula
returns.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.

Hello David

=MID(A15,2,1) gives me #VALUE!

I also looked in the cell and it has only 4035 which I would like the
formula to convert it to 4135

Thanks for taking timeout.

Thankyou.

"David Biddulph" wrote:

It should work with the cell formatted as text.
What is the value of =MID(A15,2,1)?
Did you look at your cell formatted as text to see whether there are leading
spaces or other invisible characters?
--
David Biddulph

"Steved" wrote in message
...
Hello David from Steved

It is giving me a VALUE!

The reason is that I've checked my column and it is formatted as Text
instead off General. Yes I went to another worksheet with column set as
General and it works.

Is it possible for the formula to work in either text or general.

Thankyou.


"David Biddulph" wrote:

Works for me. Perhaps you've got spaces or other invisible characters in
your cell? Have a look at =MID(A15,2,1) to see whether it finds zero.
You
say it's not functioning, but you haven't told us what the formula
returns.
--
David Biddulph

"Steved" wrote in message
...
Hello from Steved

Please what do I need to do to the below formula to change 4040 to 4140

At this time it is not functioning.

=IF(MID(A15,2,1)="0",A15+100,A15)

Thankyou.