if(Left(cell,a1)="0",a1,"0"&a1) On Fri, Oct 14, 2011 at 9:59 AM, Oliver Marshall < [email protected]> wrote:
> Anyone know how to replace a number in a cell but only if it occurs at the > start of the cell?**** > > ** ** > > I have a column of phone numbers (01234 etc). Each **should** start with a > 0 however some have the 0 missed off and start with a number. In order to > import these I need to insert a 0 at the start of the cell of those cells > that start with a number that isn’t 0…if that makes sense.**** > > ** ** > > Olly**** > > **** > > ** ** > > ** ** > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
