need formula help

[CRAIG20]

Hi
I ave a number 000758 in cell a1. I need a formula for cell B1 that will remove the 000 from a1 so just show 758.

thanks

 

[jeffreybrown]

How about =A1+0

or you could just put 0 in some cell >> copy >> right click A1 >> paste special >> Add

 

[CRAIG20]

is there a formula to make it drop the first 3 digits even if they are not zeros?

 

[jeffreybrown]

Are there always 6 digits?

=RIGHT(A1,3)+0

 

[T. Valko]

is there a formula to make it drop the first 3 digits even if they are not zeros?

Try this...

=--MID(A2,4,100)