SBR spreadsheet download to Excel - help - can't get date correct
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
SBR High Roller
08-22-10
203
#2
Originally posted by 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
Maybe try widening the date column??
LtD
Comment
SteveRyan
SBR MVP
11-15-11
1654
#3
Originally posted by 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
Excel does not recognize the date format from SBR. How is it written on your SBR spreadsheet?
Comment
EXhoosier10
SBR MVP
07-06-09
3122
#4
highlight the cell and hit Ctrl+h+v+n+(type "short") hit enter
Comment
nhjxmen
SBR Rookie
04-12-12
10
#5
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?
Comment
drawster
SBR Rookie
11-03-13
23
#6
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
Comment
satana
SBR Hustler
01-05-13
71
#7
what's this SBR spreadsheet? is it downloadable for free?