Advertisement
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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

VB question

  • 02-08-2005 4:22pm
    #1
    midget lord
    Closed Accounts Posts: 956 ✭✭✭


    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?


Comments

  • #2
    Drakar
    Registered Users, Registered Users 2 Posts: 1,531 ✭✭✭Drakar


    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.


  • #3
    midget lord
    Closed Accounts Posts: 956 ✭✭✭midget lord


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


  • #4
    yop
    Moderators, Home & Garden Moderators, Regional Midwest Moderators, Regional West Moderators Posts: 16,724 Mod ✭✭✭✭yop


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


  • #5
    midget lord
    Closed Accounts Posts: 956 ✭✭✭midget lord


    Terrific. Thats after working. Thanks a million lads.


Advertisement