+ Reply to Thread
Results 1 to 8 of 8

Excel cell formating

  1. 02-12-2021, 10:36 AM #1
    daithi mcgabhann
    daithi mcgabhann is offline
    Registered User
    Join Date
    02-12-2021
    Location
    westmeath, ireland
    MS-Off Ver
    office 365
    Posts
    5

    Excel cell formating

    When i enter a full number in any cell it appears as a decimal i.e. 35 will appear as 0.35
    How can i get back to full numbers?
    Thx
    Reply With QuoteRegister To Reply
  2. 02-12-2021, 11:16 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: Excel cell formating

    Tráthnóna maith agus fáilte.

    Weird. What is the cell formatting? have you applied some odd formatting in the sheet?

    Reformat the cell(s) as general and enter the value again...

    Otherwise, read the yellow banner (top) and post a sample of the offending sheet...
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 02-12-2021, 02:46 PM #3
    daithi mcgabhann
    daithi mcgabhann is offline
    Registered User
    Join Date
    02-12-2021
    Location
    westmeath, ireland
    MS-Off Ver
    office 365
    Posts
    5

    Re: Excel cell formating

    Hello Glenn
    Much appreciate your response. The excel workbook and sheets are empty. I checked the cell format and its already on general. I again entered a few numbers and they show as a decimal.
    Looking at the yellow dialogue, it mentioned "Go advanced" to assign an attachment of the file. I cannot find and advanced or go advanced when i scroll down - am i missing something.
    Any direction on where this Go advanced is?

    Daithi
    Reply With QuoteRegister To Reply
  4. 02-12-2021, 02:49 PM #4
    daithi mcgabhann
    daithi mcgabhann is offline
    Registered User
    Join Date
    02-12-2021
    Location
    westmeath, ireland
    MS-Off Ver
    office 365
    Posts
    5

    Re: Excel cell formating

    Sorry i see go advanced icon now - let me try it....
    Reply With QuoteRegister To Reply
  5. 02-12-2021, 02:52 PM #5
    daithi mcgabhann
    daithi mcgabhann is offline
    Registered User
    Join Date
    02-12-2021
    Location
    westmeath, ireland
    MS-Off Ver
    office 365
    Posts
    5

    Re: Excel cell formating

    Uploaded file.....

    Daithi
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-12-2021, 03:17 PM #6
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: Excel cell formating

    Goto File, options, Advanced, and under "editing options" uncheck the box marked "Automatically insert a decimal point". Then click OK
    Reply With QuoteRegister To Reply
  7. 02-12-2021, 04:12 PM #7
    daithi mcgabhann
    daithi mcgabhann is offline
    Registered User
    Join Date
    02-12-2021
    Location
    westmeath, ireland
    MS-Off Ver
    office 365
    Posts
    5

    Re: Excel cell formating

    Much appreciated Fluff13

    Daithi
    Reply With QuoteRegister To Reply
  8. 02-12-2021, 04:12 PM #8
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: Excel cell formating

    You're welcome & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. conditional formating to make a cell blank once the date inside the cell becomes history
    By opusarlo in forum Excel General
    Replies: 1
    Last Post: 04-13-2015, 05:37 PM
  2. Conditional Formating-Can you use conditional formating to make a blank cell change t
    By hodkd in forum Excel General
    Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  3. Condition formating a cell in a worksheet based off formating of another cell
    By bdberger1985 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 05:52 PM
  4. Conditionak Formating based on the previous cell the current cell value shuld b white
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2010, 04:28 AM
  5. Excel cell formating and formula
    By thomaskpange in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2009, 10:20 AM
  6. Conditional formating-Is there a way to set formating for a cell
    By kosciosco in forum Excel General
    Replies: 3
    Last Post: 03-30-2006, 10:02 AM
  7. [SOLVED] Importing Word Paragraph to Excel - 1 cell, same formating -- I lose the format
    By Chris DeNardis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1