Hi,
I formated a cell to accounting with $ symbol. If I enter number it
displayes correctly. If I enter number with $ sign then the format
changes to General. Does anybody knows how to prevent this?

i.e.
If I enter "56.89" in the cell it displays as "$ 56.89".
If I enter "$56.89" in the cell it displays as "$56.89 " and cell
format changes to "General".

TIA