Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 23rd 18, 11:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2018
Posts: 1
Default 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   Report Post  
Old August 24th 18, 01:22 AM posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 62
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ? MOHAN Excel Programming 1 March 25th 08 11:00 AM
Openig CSV file format with Excel in Office 2007 jmarc Setting up and Configuration of Excel 1 August 17th 07 08:12 PM
How do I save an excel spreadsheet in pdf format (Office 2002) Shaundee Excel Discussion (Misc queries) 2 December 2nd 05 07:16 PM
convert text-format number to number in excel 2000%3f Larry Excel Discussion (Misc queries) 1 July 29th 05 08:18 PM
How do I import tables in pdf format into office excel 2003 ? New Excel 2003 User Excel Discussion (Misc queries) 1 May 23rd 05 06:31 PM


All times are GMT +1. The time now is 08:16 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017