| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I exclude the thousand sign "k" for a value
I have imported values from a website using a web query which I will use in
my formulas. However these values are abbreviated with "k" which stands for thousand, and Microsoft Excel does not seem to be able to work with this sign. Is there anyway in which I can alter the "k" into a thousand without touching the web query, and thus enable it to be used in my fomulas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to "sign" macro with "digital certificate"? | New Users to Excel | |||
| how do I count only lower case "x" and exclude upper case "X" | Excel Worksheet Functions | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
| convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
Threaded Mode
