The way numbers are displayed

[Pnw]

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!

 

[Niek Otten]

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


|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!

 

[Pnw]

Thank you so much. How do I continue this though out an entire column?

 

[Gord Dibben]

Format all "numbers" to General.

Copy an empty cell.

Select the range of "numbers" and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP