craigdev
asked on
Excel NumberFormat as Text
I am writing a phone number value out to excel but the leading '0' is disappearing each time. How do I change the numberformat of the cell to be "Text"?
with osheet.Range("F10")
.NumberFormat = ???
.Value = "080012341234"
end with
Thanks!
with osheet.Range("F10")
.NumberFormat = ???
.Value = "080012341234"
end with
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.