Formatting Question


#1

Laurence -

I hope the holidays find you well.

I have a question of formatting times. I have a spreadsheet with 20 columns, column number 3 and column number 4 are time formats (mm:ss) like 02:20 (for 2 minutes, 20 seconds).

When I run a stored procedure through analyzer and copy and paste my results in my spreadsheets the spreadsheets treats those columns as times. When I do an export through ASPOSE.Excel those columns come out as text fields and then I can not do any calculations on them.

Do you / Could you help me on how I should format those columns so they will stay time formats instead of text when they are imported.

Any help you can give will be greatly appreciated.

Thanks
SGT


#2

Hi Steven,

Could you email me your spreadsheet with those time columns? And please tell me how you export them. I will check this issue right now.