Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Office 365 Excel for MAC Number Format
When i type a number into a new workbook like 5, it shows up as .05. How do I change it so that anytime I start a new workbook, that when I type 5, 5 will show up and not .05?
I have not created a template. That is the workbook that comes up when I say new workbook. There used to be - File-Options-Advanced-Automatically insert a decimal point - uncheck the box but I can not find it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Office 365 Excel for MAC Number Format
On 8/23/2018 5:40 PM, GP wrote:
When i type a number into a new workbook like 5, it shows up as .05. How do I change it so that anytime I start a new workbook, that when I type 5, 5 will show up and not .05? I have not created a template. That is the workbook that comes up when I say new workbook. There used to be - File-Options-Advanced-Automatically insert a decimal point - uncheck the box but I can not find it. ..05 would be 5%...the cell number format must be set. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ? | Excel Programming | |||
Openig CSV file format with Excel in Office 2007 | Setting up and Configuration of Excel | |||
How do I save an excel spreadsheet in pdf format (Office 2002) | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do I import tables in pdf format into office excel 2003 ? | Excel Discussion (Misc queries) |