It looks like your "numbers" are in fact text.
With the "number" in A1, put this formula in another cell:

=VALUE(A1)

You can format that cell the way you like

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Pnw" wrote in message ...
|I have a price sheet that displays prices like this 6.26248371689101 need to
| change them to display $6.26 have tried currency, accounting, everything.
| Please help
| Thanks for any help!