M
mad_dad
I have to work on any number of spread sheets that end up having the
leading "Zero" that is "0" removed...
At present I have a sheet with 32K rows of details and phone numbers...
The problem is that where it is a Mobile number the leading "0" has
been removed.
ie. 0404122345 is now 404122345
How do a do a lookup so that I can add / insert a leading "0" where any
of the phone numbers start that with a 4 have a leading 0 inserted?
Have tried to use the Filter function... But this feature appears to not
work in Office 2007, as expected. Select a Number Filter and "Begins
with" 4 ... Always returns Zero results.
Then depending on what format the col is set to, it removes the leading
zero any way...
..... Any one care to provide some training... North side Brisbane..
Office 2003 worked, but I can not get 2007 to play ball. It must be me.
leading "Zero" that is "0" removed...
At present I have a sheet with 32K rows of details and phone numbers...
The problem is that where it is a Mobile number the leading "0" has
been removed.
ie. 0404122345 is now 404122345
How do a do a lookup so that I can add / insert a leading "0" where any
of the phone numbers start that with a 4 have a leading 0 inserted?
Have tried to use the Filter function... But this feature appears to not
work in Office 2007, as expected. Select a Number Filter and "Begins
with" 4 ... Always returns Zero results.
Then depending on what format the col is set to, it removes the leading
zero any way...
..... Any one care to provide some training... North side Brisbane..
Office 2003 worked, but I can not get 2007 to play ball. It must be me.