Guest
I am pasting textinfo from an xml-file into a cell but Excel interpetrates it as a date and that is not my intention ??
How to force cellformatinng in VBA ?
How to force cellformatinng in VBA ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
You can also pre-format the cell before inserting the value. Use the Format property of the cell or range object. Try recording a macro to get you started. Here, I simply formatted cell F5 as Text.
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
Code:
Range("F5").Select
Selection.NumberFormat = "@"While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
- Status