Currency Formatting.

[Guest]

I have formatted number ( say 53.345 ) to currency format with $ symbol and
2 decimals. When I do this, I don't see any change in the display. But when I
place my cursor in the cell and press return, then the format changes to
currency. Please note that the data is coming from Query thru ODBC
connection to SYBASE. Thx.

 

[Bob Phillips]

That is because the data is importing as text, which doesn't format, and
only gets converted to a number, which does format, when you edit it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Your data looks numerical but is text because of the infeed.

Select an empty cell formatted to General and Edit>Copy.

Select all your data and Paste Special>Add>OK>Esc.

Your data will be coerced to numbers.


Gord Dibben Excel MVP


On Mon, 31 Oct 2005 15:08:02 -0800, "John Smith" <John

 

[Guest]

Thank You, Mr. Gord Dibben. Your solution has worked.