Ask Your Question
0

how do I change existing text into a currency?

asked 2019-12-07 14:50:14 +0200

Applejack gravatar image

I've formated the cells but it only changes when I re-enter the cell, not on the existing numbers? What am I missing?

edit retag flag offensive close merge delete

Comments

The details of your question are unclear, since text cannot be formatted as currency and the title using phrase existing text implies your data are of type "text" while your details talk about "existing numbers" (and type text is not equal to type number).

Currency is a decimal number having (in general) two decimal places (see OASIS ODF Specification - Currency). You could try text-to-number conversion, but in no way changing the format of a cell having text will change the type of the cells data (text will be kept as text - regardless of the format)

(Hint: To convert text that looks like numbers you could use Data -> Text to Columns while the column containing the data being selected and using Column TypeStandard)

For an answer specific to your case, it would be helpful that you upload an anonymized sample file, just having the essential data.

Opaque gravatar imageOpaque ( 2019-12-07 15:01:03 +0200 )edit

I'm in calc, the cell contains numbers, after entry, I formated the cell to currency, expecting to show 2 decimal places and £ symbol. But it didn't change. in the next cell also formatted, in the same way, I typed a number and the formatting worked. £ 10.00

Applejack gravatar imageApplejack ( 2019-12-07 20:19:07 +0200 )edit

If it does not change on formatting, they are not numbers at the beginning, the data just look like numbers but are text in fact.

Opaque gravatar imageOpaque ( 2019-12-08 23:34:30 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-12-09 17:57:59 +0200

Applejack gravatar image

Removing the formating 'Clear Direct Formatting' then reformating as currency.

That worked Thank you.

edit flag offensive delete link more
0

answered 2019-12-08 20:55:55 +0200

erAck gravatar image

See this FAQ, the procedure also works if the text string is convertible to a currency amount in the current locale.

edit flag offensive delete link more

Comments

Removing the formating 'Clear Direct Formatting' then reformating as currency.

That worked Thank you.

Applejack gravatar imageApplejack ( 2019-12-09 17:56:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-07 14:50:14 +0200

Seen: 1,071 times

Last updated: Dec 09 '19