Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel changes decimal
Newly installed Office 2008 for Mac inserts decimal, for example, 17
becomes 1.7. How to fix? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel changes decimal
Hi,
I don't know where it is in Excel 2008 but in 2003 you go Tools|Option|Edit and un-check fixed decimal places so I guess you might look in Help for Fixed Decimal Places and try that. Mike "davidcay" wrote: Newly installed Office 2008 for Mac inserts decimal, for example, 17 becomes 1.7. How to fix? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel changes decimal
On 2008 there is NO such listing under tools and putting "fixed
decimal" in help returns "no results. Ayone else? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel changes decimal
On Apr 26, 9:31 am, davidcay wrote:
On 2008 there is NO such listing under tools and putting "fixed decimal" in help returns "no results. Ayone else? Options in Excel is called Preferences on a Mac and should be under the application menu. That is the menu called "Excel" in this case. Also usually accessible with "CMD-,". That's the Command key (also known as Apple key) and comma. I don't have 2008 and don't trust Microsoft to match conventions, so I can't be sure of all this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |