LinkBack URL
About LinkBacks
Paul's approach will give you the same result as my second suggestion, and both give a text result. If you want a numeric result, use
=VALUE(TEXT(A1, "000""0""00""0""00"))
... and format as 0000000000 to show the leading zero.
Paul's approach will give you the same result as my second suggestion, and both give a text result. If you want a numeric result, use
=VALUE(TEXT(A1, "000""0""00""0""00"))
... and format as 0000000000 to show the leading zero.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks