did you try formatting the row
highlight your range
right click mouse
select format cells
numbers
select the format you want
ok