SKM Datablock Report saved to Excel
SKM Datablock Report saved to Excel
(OP)
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
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






RE: SKM Datablock Report saved to Excel
You might try posting this question in the Microsoft Office forum of tek-tips.com
RE: SKM Datablock Report saved to Excel
RE: SKM Datablock Report saved to Excel
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
RE: SKM Datablock Report saved to Excel
RE: SKM Datablock Report saved to Excel
Murray Newman