I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

One quick way that'll work if you're using xl2002 (I think it was added in
xl2002) or higher:

Select the column.
Data|text to columns
On step 3 of the wizard, click the Advanced button
Check the trailing minus for negative numbers.
and finish up.

Liz J wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

--

Dave Peterson

DataText to ColumnsNextNextAdvanced....checkmark "trailing minus for
negative numbers" and OK

Finish.


Gord Dibben MS Excel MVP

On Tue, 16 Mar 2010 11:00:05 -0700, Liz J
wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

That only gives a visual change and numbers are still Text and cannot be
calculated.


Gord

On Tue, 16 Mar 2010 12:21:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

"I rest my case".
http://img190.imageshack.us/img190/3356/nonamesz.png
Micky


"Gord Dibben" wrote:

That only gives a visual change and numbers are still Text and cannot be
calculated.


Gord

On Tue, 16 Mar 2010 12:21:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

.

Not in my Excel 2003 or 2007

An image such as you posted means nothing to me.

I can do the same thing by entering -123 to start with and changing
direction then taking a screen shot of the right to left calculating.

I would like others to test please.

Enter 123- in a cell.

Change to right to left direction to display -123 then calculate with that.


Gord


On Tue, 16 Mar 2010 13:56:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

"I rest my case".
http://img190.imageshack.us/img190/3356/nonamesz.png
Micky


"Gord Dibben" wrote:

That only gives a visual change and numbers are still Text and cannot be
calculated.


Gord

On Tue, 16 Mar 2010 12:21:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

.

Mike

If you do a calculation you will get a #.value error Try the below which
should return the same text..
=T(A1)

--
Jacob


"מיכ�ל (מיקי) �בידן" wrote:

"I rest my case".
http://img190.imageshack.us/img190/3356/nonamesz.png
Micky


"Gord Dibben" wrote:

That only gives a visual change and numbers are still Text and cannot be
calculated.


Gord

On Tue, 16 Mar 2010 12:21:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

.

With all due respect I finished my experiments a long time ago.
As long as the present DG interface will remain in the "dark ages" by not
enabling WB attachments - everyone may interpret the cause of the problem as
he finds it appropriate.
I do hope that in about 3-4 month we are going to face a complete new
Interface which will eliminate such lack of clarity.
Micky


"Jacob Skaria" wrote:

Mike

If you do a calculation you will get a #.value error Try the below which
should return the same text..
=T(A1)

--
Jacob


"מיכ�ל (מיקי) �בידן" wrote:

"I rest my case".
http://img190.imageshack.us/img190/3356/nonamesz.png
Micky


"Gord Dibben" wrote:

That only gives a visual change and numbers are still Text and cannot be
calculated.


Gord

On Tue, 16 Mar 2010 12:21:01 -0700, ????? (????) ?????
<micky-a*at*tapuz.co.il wrote:

Try to change the cell(s) formatting direction from "Right-to-Left" to
"Left-to-Right".
Micky


"Liz J" wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

.