| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only basic number without dollar sign or commas (or cell formatting)?
Would there be a way to have XL2K allow user to copy a cell's result but
paste it without dollar sign and comma? What I mean is that cell K2 shows result of, say, $5,496.64 with formula of =SUM(J3:J65506) Is there a way to get it to make paste show up as the basic number, also without any of the cell formatting, so that result is 5496.64 instead of $5,496.64? Thanks! :oD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| Dollar Sign | Excel Discussion (Misc queries) | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
| Dollar sign on left side of cell | New Users to Excel | |||
| How do I align numbers where one number has a dollar sign? | Charts and Charting in Excel | |||
![StargateFanFromWork[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
