cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Output a temperature in Excel-File in degrees Celsius

ClaudioPedrazzi
11-Garnet

Output a temperature in Excel-File in degrees Celsius

Hi everyone,

When I want to put a variable in an Excel-file, but with non standard units, for example mm instead of meters, I simply divide it in the input field (see example).  But what about a temperature? I have tried different ways but without success.

It always comes out as Kelvin.  I would like Celsius °C.

 

Unbenannt1.png

Basically the question is: how do I "adimensionalize" a temperature, that is reduce the value of temperature to a simple number, without units?

 

Thanks a lot in advance

Best regards

Claudio

1 ACCEPTED SOLUTION

Accepted Solutions

I guess if you want to convert . a temperature value with °C unit . to no unit, you'll have to subtract 0 °C from the united value.

 

See if that works..

 

Success!
Luc

View solution in original post

2 REPLIES 2

I guess if you want to convert . a temperature value with °C unit . to no unit, you'll have to subtract 0 °C from the united value.

 

See if that works..

 

Success!
Luc

It does!

Thanks a lot Luc!

Unbenannt1.png

Again thanks and have a nice weekend! Claudio

Top Tags