The way numbers are displayed

  • Thread starter Thread starter Pnw
  • Start date Start date
P

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