| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
The way numbers are displayed
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
The way numbers are displayed
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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
The way numbers are displayed
Thank you so much. How do I continue this though out an entire column?
"Niek Otten" wrote: 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! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
The way numbers are displayed
Format all "numbers" to General.
Copy an empty cell. Select the range of "numbers" and EditPaste SpecialAddOKEsc. Gord Dibben MS Excel MVP On Thu, 6 Mar 2008 14:47:02 -0800, Pnw wrote: Thank you so much. How do I continue this though out an entire column? "Niek Otten" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
| whole Numbers entered; percentages displayed. | Charts and Charting in Excel | |||
| Numbers displayed in the 100th decimal instead on 1,000 | Excel Discussion (Misc queries) | |||
| Change the way numbers are displayed in Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
| formatted numbers displayed as ##### | New Users to Excel | |||
Linear Mode
