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!
 
Thank you so much. How do I continue this though out an entire column?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
help with formats please 2
How to stop Excel from rounding a number? 3
144hz via DVI to Display port 8
What makes people want to buy this NetBook 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Need Macro... 8
Need Text box value to be $5,000.00 not 5000 3

Back
Top