I'm building a database from scratch. Currently I have an Excel sheet that is massive and can't really work due to the amount of data stored. I'm using a SQL Server database to store the data. 

Right now, all but one of the columns I use work. There is an ID that I need to use in the majority of my database. Unfortunately, half the IDs are alphanumeric and have are numbers (no letters). To get the data from Excel to SQL Server, I stored half the data as `float` and the other half as `NVARCHAR`. Once the data was out of Excel, I created a third column and combined the data using the code seen below:

```
UPDATE dbo.Table
SET ID = CONVERT(NVARCHAR(255), ISNULL(NumID, N'')) + N'' + CONVERT(NVARCHAR(255), ISNULL(LetID, N''))

```

After running the code, I've created a new problem. The numeric data is now written as "4.01867e+007" rather than "40186720".

Does anyone know why or how to fix this? I would like the data to read as "40186720" rather than have letters to make it easier to use.