| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Excel 2003
A friend has entered a long list of amounts in a column in Excel 2003.
Unfortunately, he entered the figures as set out below and Excel thinks the numbers with a fullstop after the thousands are text: 1.234.56 3.567.89 354.87 I have tried several ways to fix the errors, e.g., Replace, Substitute functions, but without success. I do not know how to do macros but I think one could be the answer. Any help would save him lot of work and would be greatly appreciated. Denis Sorry, I posted in Misc. before noticing this group. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro Excel 2003
See your other post in public.excel.misc
"Eddie O'Shea" wrote in message ... A friend has entered a long list of amounts in a column in Excel 2003. Unfortunately, he entered the figures as set out below and Excel thinks the numbers with a fullstop after the thousands are text: 1.234.56 3.567.89 354.87 I have tried several ways to fix the errors, e.g., Replace, Substitute functions, but without success. I do not know how to do macros but I think one could be the answer. Any help would save him lot of work and would be greatly appreciated. Denis Sorry, I posted in Misc. before noticing this group. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Macro | Excel Discussion (Misc queries) | |||
| Help with Macro in Excel 2003 | Excel Programming | |||
| Excel 2003 VBA Macro | Excel Discussion (Misc queries) | |||
| Macro in Excel 2003 | Excel Programming | |||
| Excel 2003 macro | Excel Programming | |||
Linear Mode
