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!

.