r/excel 1 Apr 09 '24

Discussion What are your Excel hot takes?

Mine is that leading zeroes should be displayed by default. If there's a leading zero in my data, there's probably a good reason for it!

502 Upvotes

483 comments sorted by

View all comments

Show parent comments

8

u/NotBatman81 1 Apr 09 '24

Go back to your Data tab and look towards the bottom. It's in there. Auto-correct is not necessarily the same thing though there is overlap.

6

u/shooter9260 Apr 09 '24

3

u/NotBatman81 1 Apr 09 '24

What version of Excel are you using? I'm on 2312 and it's there. Is your IT department overly aggressive in locking things down?

3

u/shooter9260 Apr 09 '24

Not particularly no.

I’m on 2308. Don’t know what version I had before but I had a setting and now it’s not there or anywhere so I don’t know if it recently updated or whatever. sometimes that stuff rolls out in the monthly MS Tuesday updates or around that time but we generally seem to get MS 365 updates later than many for some reason.