Jump to content
Sign in to follow this  
Hippocode

Sorting numbers in subrows

Recommended Posts

The Descending and Ascending Sort function in the worksheet are nice but don't work properly on numbers placed in a text field.

A lot of PIOS use a number to trace them, ideal to list them in a worksheet. Sadly, that number is stored as a string and won't sort properly

Sorting will give the following:

1

10

11

2

21

22

3

4

5

6

7

8

9

Is there any way to sort them the right way and not tread them as if they were strings ??

Edited by hippothamus

Share this post


Link to post

add the value function, =VALUE('xxxx'.'xxx')

Value treats text as numbers.

hth

mk

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×