Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Values not pasting numbers
I had a number of columns that contained formulas and i used the "Paste
Values" fuction to replace the formula. The problem is that the values are not being treated like numbers. If I look at the values in the cells the numbers appear with with the justification characters beside them. If I manually remove the character or reinput the number it will then fuction as a number. If i don't I cannot perform even simple calculations like SUM with them. The results are incorrect. Is there any way to remove these characters accross many cells at the same time? I've tried to change the formatting and deselecting all justifications and that doesen't work either. Ive never seen this before, a number that looks like a number but isn't a number. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting a forumla w/o the paste/special/value | Excel Discussion (Misc queries) | |||
pasting a forumla w/o the paste/special/value | Excel Discussion (Misc queries) | |||
How flip a selection before pasting - Paste special | Excel Discussion (Misc queries) | |||
Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting | Excel Discussion (Misc queries) | |||
Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) |