Convert your column from a number formatting to text formatting. Your leading 0 should come up. On Oct 14, 2011 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
