Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal point in general format
Since I switched to someone's computer, same program, and I'm updated my date
in excel, I'm having trouble trying to get rid of a decimal point in a cell. My column is in numerical order, no decimal point or fractions. Now when I type in my next number, it automatically gives a decimal point (thinking it is working with currency). I tried changing the format in the cell, but it won't change it as a whole number. I'm also trying to figure out why it can not recognize $ and insert the decimal point automatically. This is a different column where I record currency. For example, I would type in 500 and it would come out as 5.00. Before it used to automatically recognize it as $500.00. Now I have to punch in 4 zeros just for it to insert the decimal in the correct digit. What am I doing wrong? -- live in Phx |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal point in general format
Go to Tools - Options, Edit. Uncheck the box for "Fixed decimal places"
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "phoenix native" wrote: Since I switched to someone's computer, same program, and I'm updated my date in excel, I'm having trouble trying to get rid of a decimal point in a cell. My column is in numerical order, no decimal point or fractions. Now when I type in my next number, it automatically gives a decimal point (thinking it is working with currency). I tried changing the format in the cell, but it won't change it as a whole number. I'm also trying to figure out why it can not recognize $ and insert the decimal point automatically. This is a different column where I record currency. For example, I would type in 500 and it would come out as 5.00. Before it used to automatically recognize it as $500.00. Now I have to punch in 4 zeros just for it to insert the decimal in the correct digit. What am I doing wrong? -- live in Phx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number format still uses decimal point | New Users to Excel | |||
in Excel 2007, how do you remove the decimal point in General | New Users to Excel | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
format inplied decimal point | Excel Discussion (Misc queries) |