Hi :)
I think the usual way is to avoid typing in the $ sign and just let the cell
formatting put that in front for you.
Regards from
Tom :)
From: Steve Edmonds steve.edmo...@ptglobal.com
To: users@global.libreoffice.org
Sent: Saturday, 9 March 2013,
Hi Steve,
I only have 4.0.1.2 installed, but my guess is that with the comma in
there, or possibly the dollar sign, or maybe both, when you are pasting
it, calc thinks it is text and not a number. That causes the left
alignment and not being dividable since text can't be divided.
Don
On
On 03/09/2013 01:00 AM, Steve Edmonds wrote:
Hi.
If I type or paste $2,441.99 into a cell in calc (3.6) it is left
aligned. If I right click format cell it states number-general.
If I divide it by 2 I get #value!
How do I get LO to recognise this as a number. I found a long winded
way,
On 2013-03-10 01:23, Johnny Rosenberg wrote:
2013/3/9 Steve Edmonds steve.edmo...@ptglobal.com:
Hi.
If I type or paste $2,441.99 into a cell in calc (3.6) it is left aligned.
If I right click format cell it states number-general.
If I divide it by 2 I get #value!
How do I get LO to recognise
:)
From: Steve Edmonds steve.edmo...@ptglobal.com
To: Dan Lewis elderdanle...@gmail.com
Cc: users@global.libreoffice.org
Sent: Saturday, 9 March 2013, 21:41
Subject: Re: [libreoffice-users] Currency conversion/display in calc
On 2013-03-10 07:12, Dan Lewis wrote:
On 03/09/2013 01:00 AM