View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen
 
Posts: n/a
Default numbers in Excel

How are you saving the file? I have had this for .prn files, where I have to
left justify and set the column width to 12 (pixels) before saving as a .prn
file.

Other suggestion which it seems like you might have tried was to add spaces
with a new cell like this =RIGHT(" "&A1,12)

that's the best I can think of
--
Allllen


"Russell Hampton" wrote:

I have a list of account numbers that are 3, 4 and 5 digits in length. They
of course print right justified. I need to have each cell in the column be 12
characters in length, even if the account number is only 4 digits long. I
have added spaces and Excel ignores them. Indent works but I can't control
the length of the indent. I need this to be able to move the file to an
HP3000 processing system. Does anyone have any ideas?