All, I have a cell in my workbook that contains the number 8, though due to the formatting on that cell it appears as "008", as it should. However when I try and use that number in my macro it becomes "8" again, is there a way of retaining the leading zero's?
I tried:
Please Login or Register to view this content.
Last edited by ChrisMattock; 02-19-2010 at 03:21 PM.
I am definately going to stop bothering you guys soon, whenever I ask a question I have been trying to solve I find the answer two minutes later. This time (in case anyone cares) I changed the cell format to "text" and the variable from an integer to a string. Simple. Just like me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks