| View previous topic :: View next topic |
| Author |
Message |
totalnoob
Newbie
Joined: 08 Dec 2011
Posts: 2
|
 Posted: Thu Dec 08, 2011 10:10 pm Post subject: Need Help with a formula |
 |
|
I want to sort 9 digits in a cell by only the last 2 digits. I tried inserting a new column in (column B) and then tried an MS Excel formula =RIGHT(A1,2) but now that I think about it wouldn't the formula =VALUE(RIGHT(A1,2)) work for this?
Let me know guys and gals.
Thanks,
ViC |
|
| Back to top |
|
 |
totalnoob
Newbie
Joined: 08 Dec 2011
Posts: 2
|
| Posted: Thu Dec 08, 2011 10:31 pm Post subject: =VALUE(RIGHT(A1,2)) doesn't work |
|
|
Ok, i tried this formula and it works fine in excel but doesn't work with openoffice calc....any suggestions?
Thanks,
ViC |
|
| Back to top |
|
|
floris_v
Moderator
Joined: 12 Jul 2007
Posts: 4601
Location: Netherlands
|
| Posted: Fri Dec 09, 2011 12:21 am Post subject: |
|
|
Use ; instead of ,
| Code: | | =VALUE(RIGHT(A1;2)) |
works for me.
If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum |
|
| Back to top |
|
|
|
