| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Question
I have an Excel spreadsheet with currency.
If the value is $4.50 for example, it shows in the formula bar as 4.5 and merges into Word this way. I have set my options to precision as displayed. I have set my decimal places to 2. I have tried a custom number format. Nothing is working. any suggestions? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Question
Try using =TEXT(A1,"$#,##0.00_);($#,##0.00)") When the cell merges it shoud
see it as text $4.50 Good luck "Stormy" wrote: I have an Excel spreadsheet with currency. If the value is $4.50 for example, it shows in the formula bar as 4.5 and merges into Word this way. I have set my options to precision as displayed. I have set my decimal places to 2. I have tried a custom number format. Nothing is working. any suggestions? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Question
FormatCellCurrencySymbol - choose none
EircBB "Stormy" wrote: I have an Excel spreadsheet with currency. If the value is $4.50 for example, it shows in the formula bar as 4.5 and merges into Word this way. I have set my options to precision as displayed. I have set my decimal places to 2. I have tried a custom number format. Nothing is working. any suggestions? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Question | Excel Discussion (Misc queries) | |||
| formatting question | Excel Discussion (Misc queries) | |||
| Formatting Question | Excel Worksheet Functions | |||
| Formatting Question | Excel Discussion (Misc queries) | |||
| Formatting Question | Excel Discussion (Misc queries) | |||
Linear Mode
