Solved Excel trouble formatting currency

November 1, 2013 at 15:16:31
Specs: Windows 7
Hi,
I am having trouble formatting a column to show currency. It will not show a dollar sign or the correct decimals. It was working before and I don't know if I did something or what. Right now it shows a cross symbol which moves around like an arrow if you right click.

I am hoping this is something simple. Can anyone help?


See More: Excel trouble formatting currency

Report •

#1
November 1, 2013 at 20:22:27
✔ Best Answer
Right now it shows a cross symbol

The cross symbol is the usual form the cursor takes when over the body of the spreadsheet.
It is an arrow when over the Ribbon.

See here for how the cursors behaves:

http://www.rferro.com/CIS110/resour...


It will not show a dollar sign or the correct decimals.

What does it show?

There are two formats that display the dollar sign with decimals
they are Currency and Accounting.
Have you tried either of them?

MIKE

http://www.skeptic.com/


Report •

#2
November 2, 2013 at 13:02:11
Hello,

I have tried both Accounting and Currency. Also I know how the curser moves and how to extend or shrink the cells. Also went to format cells and tried from there to insert a dollar sign and the decimal in the correct position.
Thank you for answering me.



Report •

#3
November 2, 2013 at 14:13:07
I have tried both Accounting and Currency, highlighted the cells
and nothing changes


Report •

Related Solutions

#4
November 3, 2013 at 08:34:38
Is the data being entered manually or did you import it from another source?

If you have imported the data from another source, then Excel may be reading
the numbers as TEXT.

A simply way to check is to use the ISNUMBER() function

With your data in cell A1 in cell B1 enter: =ISNUMBER(A1)

If it returns FALSE it's TEXT
If it returns TRUE it's a NUMBER

If it turns out to be TEXT, see here:

http://office.microsoft.com/en-us/e...


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#5
November 5, 2013 at 11:47:24
Hi Mike,

I just noticed your post. I had just about given up.
I tried what you suggested and it did a weird thing. It allowed me to put a number with the dollar sign and decimal in the correct place, then when I finished putting in the =ISNUMBER(A1) in the B1 cell, it did not answer the question and as I stated, removed the dollar sign and decimal.

Thanks,
Cara


Report •

#6
November 5, 2013 at 13:00:00
When you enter a Dollar Sign followed by a Number with a decimal point, in cell A1,
when you press Enter, the Dollar Sign and decimal point is removed.

Is this correct?

In cell B1 you entered the formula =ISNUMBER(A1), and it did not return True or False?

MIKE

http://www.skeptic.com/


Report •

#7
November 5, 2013 at 14:09:33
Hi Mike,

That is correct. It did not return True or False


Report •

#8
November 5, 2013 at 16:04:50
It did not return True or False

Did it give any response, like #NAME or #VALUE or did it simply remain blank?

Did you create the worksheet or did someone else create it?
Does the worksheet have any MACROS running?

MIKE

http://www.skeptic.com/


Report •

Ask Question