| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Number Format
Is there a quick way to format numbers copied from a website into Excel.
I find that the numbers copied into Excel do not allow any operations to be performed. Thank you in advance for your help. |
|
#2
|
|||
|
|||
|
Run this macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall Regards, Peo Sjoblom "Richard" wrote: Is there a quick way to format numbers copied from a website into Excel. I find that the numbers copied into Excel do not allow any operations to be performed. Thank you in advance for your help. |
|
#3
|
|||
|
|||
|
You're copying numbers as text. Copy a blank cell. Select your "numbers"
and choose Edit/Paste Special, selecting the values and add radio buttons. Format as normal. In article , "Richard" wrote: Is there a quick way to format numbers copied from a website into Excel. I find that the numbers copied into Excel do not allow any operations to be performed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to get week number in month in excel ? | Charts and Charting in Excel | |||
| how do you format a number such as 6.9 if you want the 9 to look . | Excel Discussion (Misc queries) | |||
| excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
| How can I pre format all Excel comments to Tahoma, font size 12, . | Excel Discussion (Misc queries) | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
