remove a constant

[janethe pain]

I have copied and pasted info from a website on to a spreadsheet (it's info from bank statements and it won't allow me to do a web link) but I can't make columns of numbers add up. The problem seems to be because all the cells have a constant. (found this by evaluating formula) Is there a way to remove the constant? I have tried all sorts of things-format column, paste special etc. but nothing works. Any ideas please?

[Jakobshavn]

What is the constant?

[janethe pain]

Hi
each cell has the an abbreviation of the name of the sheet I copied then the cell referance - i.e. if I click on a cell and look in evaluate formula it says referance sheet!$A$92 the evaluation box has the contents of the cell in italics
it won't allow me to step in and alter it

[Ursul]

Is there such a large amount of information that you couldn't have just entered the figures manually and then created your own formulas without the hassle of having imbedded issues like this?

I imagine the bank won't let you link as a security issue - for your sake not theirs!

[FDibbins]

It would help if we could see a sample of what you are working with (no sensitive info).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[janethe pain]

Hi Ursul

Thanks for replying and I don't wish to sound rude and in the nicest possible way, if it was a small amount of info manual entering would be the obvious way to do it
the security issue is why I can't, and wouldn't want to put a sample on here

Thanks anyway

[janethe pain]

Hi FDibbins

Sorry, can't do a sample - private info - but, great news - a friend told me the constant is to do with the set up and keeps the rows in line for printing. So after some messing around I found if I do simple copy and paste of info to spreadsheet, copy and paste as unformatted text to a word document, then copy and paste text only to spreadsheet it solves the problem. Bit of a palava and I bet there's an easier/quicker way but it works!