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)


"John Smith" <John wrote in message
...
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.