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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
.NumberFormat = "@"
- Thread starter campbere
- Start date
@ means that excel will not touch any of the text in the cell.
examble
i have a date format set on a cell for somthinng like dd-mm-yy
when i type for example
6/2/2020
excell will change it to
06-02-20
@ makes excel leave it along
Karl Pietri
lordhuh.pota.to
examble
i have a date format set on a cell for somthinng like dd-mm-yy
when i type for example
6/2/2020
excell will change it to
06-02-20
@ makes excel leave it along
Karl Pietri
lordhuh.pota.to
- Status
Similar threads
- Locked
- Question
- Locked
- Question