LinkBack URL
About LinkBacks
Hi all,
I have a list of numbers and want to make a formula to display the first two digits.
For example I am using =LEFT(D4,1+1) on the number 0102 and I get 10
Whatever I do I cannot get it to recognise the 0
Can someone please help
Thanks
legepe
Hi all,
I have a list of numbers and want to make a formula to display the first two digits.
For example I am using =LEFT(D4,1+1) on the number 0102 and I get 10
Whatever I do I cannot get it to recognise the 0
Can someone please help
Thanks
legepe
Last edited by NBVC; 05-29-2010 at 09:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks