| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Format Numbers Without Fixed Decimal
How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried
the General but I get 0.01 instead of 1 I am using Office 2007. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Format Numbers Without Fixed Decimal
Format the cells in question as text....
"bgray1796" wrote: How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried the General but I get 0.01 instead of 1 I am using Office 2007. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Format Numbers Without Fixed Decimal
Thanks for a quick response. The "Text Format" works fine.
"Wood Grafing" wrote: Format the cells in question as text.... "bgray1796" wrote: How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried the General but I get 0.01 instead of 1 I am using Office 2007. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Format Numbers Without Fixed Decimal
I suspect you have ToolsOptionsEdit "Fixed decimal places" with 2 DP enabled.
This will change 1 to .01 or 10 to 1 Uncheck this feature. Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 12:22:15 -0700, bgray1796 wrote: How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried the General but I get 0.01 instead of 1 I am using Office 2007. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Format Numbers Without Fixed Decimal
I think you have set the option to make all numbers have two decimal places.
Click the Office button; open Excel options and look around - my XL2007 computer is asleep and I cannot recall the exact location of this setting If you type 1 and get 0.01 then this is your solution! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "bgray1796" wrote in message ... How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried the General but I get 0.01 instead of 1 I am using Office 2007. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Format Numbers Without Fixed Decimal
I had the same problem and didn't like using text for numbers.Excel 2007 does
not have ToolsOptionsEdit like previous versions. Instead use: Office ButtonExcel OptionsAdvanced TabEditing Options sectionAutomatically insert a decimal point = uncheck. "Bernard Liengme" wrote: I think you have set the option to make all numbers have two decimal places. Click the Office button; open Excel options and look around - my XL2007 computer is asleep and I cannot recall the exact location of this setting If you type 1 and get 0.01 then this is your solution! best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "bgray1796" wrote in message ... How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried the General but I get 0.01 instead of 1 I am using Office 2007. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed Decimal Question | Excel Discussion (Misc queries) | |||
| How to convert decimal numbers to time format | Excel Worksheet Functions | |||
| format a decimal number to nondecimal numbers | Excel Discussion (Misc queries) | |||
| My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Linear Mode
