Link to home
Start Free TrialLog in
Avatar of craigdev
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!
ASKER CERTIFIED SOLUTION
Avatar of ElrondCT
ElrondCT
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial