SKM Datablock Report saved to Excel 1

[EddyWirbelstrom]

I use SKM Powertools 'Datablock Format' to place study results on single line diagrams.
To present study results in tabular form I save 'Datablock Report' to Excel. However the numbers in the resulting excel spreadsheet can not be formatted. When an excel data sort is attempted, excel informs that the numbers are 'words'.
I am getting around this by multiplying the 'words' by 1.0.
The result can then be formatted.
Does anyone have a quicker way ?
Murray Newman
Bunbury, West Australia

 

[dpc]

Seems like there should be an Excel function to convert text to numbers.

You might try posting this question in the Microsoft Office forum of tek-tips.com

 

[jbartos]

Suggestion: The Excel can "Format," "Cell," and "Number" within different categories. The number can be general, number, text, time, date, special, etc. The Text number, e.g. 12, can be multiplied by the General Number (default), e.g. 12 to give a result 144.

 

[EddyWirbelstrom]

Thanks dpc and jbartos
I can not change the format of the 'number word' saved into Excel from the SKM source file by going 'Format Cell', > 'Number', > 'Number' and entering number of decimal places. Or any other excel number category.
Although Excel sorts 'number words', they must be treated as words when using logic operators.
Also the number of decimal places can not be changed.
I get around it by laboriously multiplying the 'word' colums by 1, and hiding the 'word' columns.
Murray Newman
Bunbury, West Australia

 

[jghrist]

You can multiply a range by the number 1 less laboriously by putting 1 in a cell, copying to the clipboard (/Edit/Copy or Ctrl-C). Then highlight your imported data and /Edit/Paste Special/Values/Multiply.

 

[EddyWirbelstrom]

Thanks jghrist - it works! You can even delete the number 1 when done. Your excel help will save me hours.
Murray Newman