NathanGriffiths
Programmer
Hi,
I have come up against a strange (to me anyway) problem in an Excel spreadsheet I am trying to import to SQL Server.
When imported, some of the values for cells were NULL although they contained identical values to cells above and below them. I traced the source of the NULL problem to the formatting, so I though I would just be able to reformat all the cells the same to allow a successful import.
My problem is that when I apply formatting to some of the cells it just does not seem to have any effect.
e.g. changing format of a column from Text to Number (2 d.p.) - some of the cells will reformat to Number but some appear to stay as text and there is nothing I can do to force them to change:
Before:
1
1
1
1
After:
1.00
1.00
1 <- this cell does not change!
1.00
The spreadsheet appears to have been created by cutting and pasting bits of other spreadsheets together, so perhaps this is where the problem originates, but can anyone tell me whats going on?
thanks,
Nathan
I have come up against a strange (to me anyway) problem in an Excel spreadsheet I am trying to import to SQL Server.
When imported, some of the values for cells were NULL although they contained identical values to cells above and below them. I traced the source of the NULL problem to the formatting, so I though I would just be able to reformat all the cells the same to allow a successful import.
My problem is that when I apply formatting to some of the cells it just does not seem to have any effect.
e.g. changing format of a column from Text to Number (2 d.p.) - some of the cells will reformat to Number but some appear to stay as text and there is nothing I can do to force them to change:
Before:
1
1
1
1
After:
1.00
1.00
1 <- this cell does not change!
1.00
The spreadsheet appears to have been created by cutting and pasting bits of other spreadsheets together, so perhaps this is where the problem originates, but can anyone tell me whats going on?
thanks,
Nathan