1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How do I stop dates appearing when typing singular numbers?

Planning branch visits for work and I colour code each day. I want to number the visits in the order that I'll be seeing them. However, typing 1 (1st visit for the day) excel puts in a date instead. I was able to type 2, but 3 did the date thing again. How can I resolve this please?

submitted by /u/Never2cold
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#no-code spreadsheet solutions
#Excel
#dates
#branch visits
#colour code
#numbering
#visits
#typing
#1st visit
#data entry
#formulas
#data formatting
#numeric input
#input error
#order of visits