View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Changing Text To Numbers ?

Hi Bob,

Am Sun, 03 Mar 2013 10:15:06 -0500 schrieb Bob:

I tried re-formatting these copied cells as Numbers in Excel, but they
still appear on the left hand side of the cells.


select your column with the numbers, format as numbers and then Data =
TextToColumns = Fixed width = Finish


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2