LinkBack URL
About LinkBacks
nlyrk0 
If you want to see all the digits, you'll need to format those fields as text.
Something like this in a larger scale:
Sub FormatBigNos(): Dim S As String ActiveCell.NumberFormat = "@" S = CStr(ActiveCell): ActiveCell = S End Sub
If you want to see all the digits, you'll need to format those fields as text.
Something like this in a larger scale:
Sub FormatBigNos(): Dim S As String ActiveCell.NumberFormat = "@" S = CStr(ActiveCell): ActiveCell = S End Sub
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks