Visio Discussions > ShapeSheet & Smart Shapes

Change number from measurement to just a decimal number

(1/1)

**Mouthpear**:

How do you change a number that is a measurement in to a regular number.

How it comes out

Sheet.1!Width = 50.000 mm

What is needed.

Sheet.1!Width = 50.000

**Surrogate**:

Where you need watch these numbers:

* Size & position window

* Shape's field

**hidden layer**:

It looks like a shapesheet's cell (Width)

This is already a number - it just looks like no number but it is.

If you have a look at the field LocPinX you can see that there's already a formula in it which uses the value of Width (if you take a simple rectangle).

For other cells you can check if these are numbers (to calculate with):

1. insert the section "user defined cells" or a new line in it

2. insert the formula: (the cell you want to calculate with) * 2

3. If the calculation is correct, it's easy

4. If not you have to separate the "numbers" (mid(...)) *1 in order to have NUMBERS.

cheers

hl

**Surrogate**:

--- Quote from: hidden layer on September 02, 2022, 03:22:16 AM ---4. If not you have to separate the "numbers" (mid(...)) *1 in order to have NUMBERS

--- End quote ---

IMHO best way use formulas like

--- Quote ---=width/1 mm

--- End quote ---

Navigation

[0] Message Index

Go to full version