Default number format in Excel

A

Agoes Rodiman

Joined
Aug 9, 2018
Messages
1
Reaction score
0
I have one excel workbook and always changes number become a date, I think its about default cell number contents. How to changes it become normal as when I enter 0 a cell content is 0 not 0/0/0 as does now.
Thanks for kind.
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum :)

Excel shouldn't change numbers to dates by default, are you working with an old / existing spreadsheet? Click on one of the cells to see the format (displayed in the ribbon under the 'Number' section):

excel number format.jpg


If it is set to Date then change it to General or Number. You can do this to multiple cells at the same time by selecting them and then making the changes. You can also right click on the selected cell(s) and then selecting 'Format cells...' for more options.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VISIO from Excel VBA 0
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Need assistance with modifying a Duplicate declaration. 13

Top