Formatting numbers

  • Thread starter highbloodpressure1949
  • Start date
H

highbloodpressure1949

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?
 
E

Eduardo

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

..0

if this helps please click yes thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top