| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - How to change the decimal sign
Example of web table before importation:
aaa 1.90 bbb 2.00 ccc 1.80 Desired values when they are in Excel: aaa 1,90 bbb 2,00 ccc 1,80 If I could import the web table as text than I could replace the digits with comma (Edit/Replace or fonction SUSTITUTE). Before that I can make that Excel recognazes the numbers as values and insert in the cells wrong values. Is it possible to prevent Excel recognizing numbers as values? Thanks. -- gilgil Excuse my english "Ron Rosenfeld" ha scritto nel messaggio ... On Wed, 9 Mar 2005 10:14:22 +0100, "gilgil" wrote: If the values are being imported as TEXT, then you could do Edit/Replace or use the SUBSTITUTE worksheet function. Then you could convert them to numbers. If the values are being imported as numbers, then give some examples as to the actual and desired values when they are in Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Place goes crazy when using the "&" Sign. | Excel Discussion (Misc queries) | |||
| Plus sign after decimal??? | Excel Discussion (Misc queries) | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
| How do you change the sign (e.g. +3 to -3 OR -3 to +3) | Excel Discussion (Misc queries) | |||
Threaded Mode
