Ask Your Question
0

how to convert text to currency [closed]

asked 2015-03-17 03:03:46 +0100

williamb gravatar image

updated 2020-08-17 17:29:21 +0100

Alex Kemp gravatar image

in LibreCalc 4.2.7.2 I have many pages and columns of spreadsheet values using "currency-as-text" (all entries preceded by single quote) How do I convert these text entries to actual currency (leading single quote removed)? The format dialog options allow me to select the cell(s) but nothing happens when I ok the change to currency.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-17 17:30:02.780599

1 Answer

Sort by » oldest newest most voted
0

answered 2015-03-17 03:36:33 +0100

m.a.riosv gravatar image

Try with Menu/Data/Text to columns.

edit flag offensive delete link more

Comments

Many thanks!

williamb gravatar imagewilliamb ( 2015-03-18 05:16:39 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2015-03-17 03:03:46 +0100

Seen: 2,550 times

Last updated: Mar 17 '15