My coworker's excel program is converting all data to decimals. He enters in 2004 as a date and it makes it 2.004
I opened the same file on my computer and it works fine. I have done all fo the formatting to try and make it a number or a general field. The general field is not showing a preview as if there is some error overriding the whole program.
He has some other numbers that he has already entered as currency and they work fine. I was able to do a =2004 and it showed as 2004 of course.