Previous Topic Next Topic

Excell

Closed
ez - Jan 29, 2009 at 01:34 AM
chadght Posts 6 Registration date Saturday October 4, 2008 Status Member Last seen April 17, 2009 - Jan 29, 2009 at 06:05 AM
Hello, allot of times i copy and paste from web doc to excell (eg with bank statements) the column with the money is not recognized by excell as a number. at the bottom right of page where it would usually show toatal of cells , it just says count. so you can't use the figures. really anoying, i tried formating the cells in different ways but no good.
cheers
aeron
Related:

1 response

Answer 1 / 1
chadght Posts 6 Registration date Saturday October 4, 2008 Status Member Last seen April 17, 2009
Jan 29, 2009 at 06:05 AM
Hello,

I will suggest you to copy and paste the characters and the values seperately. When you are pasting the values, right click and choose paste special characters from the list and then choose either currency or number, this might solve your problem
0