View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blissfully Ignorant
 
Posts: n/a
Default Can't add pay rates

am trying to add a new code with pay rates to a range titled EmployeesList
on worksheet titled Parameters. When I type in the new code in the next row
down from the existing codes it aligns itself on the right hand side of the
cell. Allof the other codes are on the left hand side with formatting of
number and general alignment. When I change the new codes format to number
and general alignment it centers it in the middle. When I go to worksheet
Time Entry and type in the new code it comes up with #N/A in the cell where
the rate that is inputted with it on Parameters sheet should show up.

So, instead of trying to add a new code, I changed the number of an old code
and it went from being left indent to right indent and it then came up as
#N/A when I tried to use it.
Please Help!!!