Macro Excel 2003

E

Eddie O'Shea

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro 5
Big Problem with Excel 2000 / 2003 2
Excel 2003 2
Running Excel 2000 VBA Application on Excel 2003 3
Excel 2007 Charting macro 1
Excel 2000 VBA Application on Excel 2003 2
Working in Excel 2003 but not Excel 2007. Can not protect sheet. 2
Run Macro Automatically When Excel 2003 Opens 2

Top