SBR spreadsheet download to Excel - help - can't get date correct

[cyberbabble]

I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
Can anybody help?
Thanks

[LtDementia]

I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
Can anybody help?
Thanks

Maybe try widening the date column??

LtD

[SteveRyan]

I am downloading my SBR spreadsheet to Excel. Everything is OK except the date. Date shows as an integer. Excel format cell option just gives me ######.
Can anybody help?
Thanks

Excel does not recognize the date format from SBR. How is it written on your SBR spreadsheet?

[EXhoosier10]

highlight the cell and hit Ctrl+h+v+n+(type "short") hit enter

[nhjxmen]

Are you programming yourself or using someone else's program? I've been trying to figure how to import into excel for a long time now. Any tips?

[drawster]

in Excel you have the data tab and you have an option to extract data from an html.

if you want to automate it... before extracting the data, go to the developer tab ->record macro -> after extracting stop the recording and view the macro code-> start learning a little vba -> modify at your will

[satana]

what's this SBR spreadsheet? is it downloadable for free?