[QUOTE=Killer42]There are probably many ways to achieve this such as selecting the range and invoking a macro. But I have a strong feeling that there is a very quick and easy way to change your text values to numbers, but just can't think of it.
...
Ah! Found it at last. There's an entry in Excel's online help entitled Convert numbers stored as text to numbers. The sub-heading "A whole range at once" gives...
michelle montgomery
Last Activity: Sep 4 '07, 03:59 AM
Joined: Feb 28 '07
Location:
-
Sorry about the confusion i am just learning about merging spreadsheets. I did manage to change the formula on the 10000 items manual by f2 but i would still like to be able to work out how to change the formulas with out having to change every single item manually. Is there a way to f2 a range of cells instead of each one individually.Leave a comment:
-
Yes i have just tested on list and by pressing f2 on the suppliers code and then entering the pricing is brought through. I also just had a list of codes that had spaces at the end of the code and if i selected f2 then backspaced back to the end of the code and pressed enter the pricing registered and came through. My problem with this is that i had 11000 codes from the supplier that i need to f2 we only stocked 500 items....Leave a comment:
-
Also when i change the format in the cell by say typing over the code and it then attaches the appropriate pricing the cell format has a message that says
The number in this cell is formatted as text or followed by an apostrophe. ?...Leave a comment:
-
We have tried to change the entire column to text then number to see if we could get the code to recognise each other but no luck....Leave a comment:
-
Sorry it has taken so long to get back to you but work has been an nightmare. I cant copy the formulas over but i will try to expain. I highlight thecodes from our computing sytem for the first section of the look up and then i highlight all the information from the suppliers spreadsheet by starting at row 1 and scrolling down to the end then i select the colum (suppliers spreadsheet) that the pricing is in (example 5) then type False for the last...Leave a comment:
-
I am using the v lookup and choosing the code cells for the look up...Leave a comment:
-
Excel v lookup
I am trying to merge two spreadsheets together for a price update and the codes on both spreadsheets are the same but they do not register. If i type over one of the codes it then will register and the appropriate information will be brought over. I believe it has something to do with the format of the cell but i cant work it out.
No activity results to display
Leave a comment: