View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Formatting numbers

Hi,
Highlight the range, right click on the mouse, cell format, custom, enter

..0

if this helps please click yes thanks

"highbloodpressure1949" wrote:

I have a spreadsheet that needs to have .5 entered into different cells.
When I enter the number, what shows up is 0.5. Since there are several
different cells, it makes the row too long to print on one sheet. I've tried
deleting the 0, but when I hit the 'Enter' key, it puts it right back where
it was. Can anyone tell me how to fix this?