That worked! Thank You!
Now, I'm having another problem, if the value of T2 is "01", only "1" is displayed. I have used the format cells > custom > 00 but it still doesn't work... I would like it to display a LETTER LETTER DIGIT DIGIT LETTER always, whether there is a zero or not. I have tried to enter ##00# but that doesn't do the trick
Last edited by ibsoxfan; 02-18-2013 at 06:01 AM.
Try Text to column.
Happy to Help
VISHA
Click *, if the suggestion helps you!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks