Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting numbers
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting numbers as 1st 2nd | Excel Worksheet Functions | |||
formatting numbers | Excel Discussion (Misc queries) | |||
Formatting Numbers | Excel Discussion (Misc queries) | |||
Formatting numbers | Excel Worksheet Functions | |||
Formatting numbers | Excel Discussion (Misc queries) |