×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SKM Datablock Report saved to Excel

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

RE: SKM Datablock Report saved to Excel

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

RE: SKM Datablock Report saved to Excel

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.  

RE: SKM Datablock Report saved to Excel

(OP)
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



RE: SKM Datablock Report saved to Excel

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.
 

RE: SKM Datablock Report saved to Excel

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources