If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

VB question

midget lord · 2005-08-02 16:22:27

I got a xl spreadsheet from a client which was exported from a bookkeeping package. Unfortunately it put a space between the € sign and the numbers. So my question: Is there a VB command which can remove the space and make XL recognise the numbers?

Options

02-08-2005 5:22pm

#1

midget lord

Closed Accounts Posts: 956 ✭✭✭

Join Date: November 2003

Posts: 925

I got a xl spreadsheet from a client which was exported from a bookkeeping package. Unfortunately it put a space between the € sign and the numbers. So my question:

Is there a VB command which can remove the space and make XL recognise the numbers?

0

Comments

Options
#2 02-08-2005 5:24pm
Drakar

Registered Users Posts: 1,531 ✭✭✭

Join Date: October 2001

Posts: 1337

Simple option would be to do a search and replace for '€ ', replacing it with nothing. Then reformat the cells which contain the numbers into the correct currency format.

0
Options
#3 02-08-2005 5:25pm
midget lord

Closed Accounts Posts: 956 ✭✭✭

Join Date: November 2003

Posts: 925

How do i do this search drak? im a complete VB novice.

0
Options
#4 02-08-2005 5:49pm
yop

Moderators, Home & Garden Moderators, Regional Midwest Moderators, Regional West Moderators Posts: 16,724 Mod ✭✭✭✭

Join Date: July 2001

Posts: 15163

I think he means do it in Excel with a find and replace.

0
Options
#5 03-08-2005 9:01am
midget lord

Closed Accounts Posts: 956 ✭✭✭

Join Date: November 2003

Posts: 925

Terrific. Thats after working. Thanks a million lads.

0