Excel transform my numbers in decimal

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,
I write 1920 for example and when i change cell excel trasforms it in 19,20.
Why? i controlled the cell format: it's "general".
What is the way to obtain that if I write 1920 excel leave it 1920 and not
19,20?
Thank you very much
LucaM
 
Tools>Options>Edit, uncheck Fixed decimal

--
Kind regards,

Niek Otten

"(e-mail address removed)"
 
You must log in or register to reply here.

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

How do you convert existing numbers? 5
formula for decimal point 4
switch off transforming number into date 1
format 9
Red cell for negative numbers in Excel 1
How do i compare numbers in cells with formula 3
Moving Decimal Point 2
Request for design ideas moving from data entry in spreadsheet toUserForm 2

Back
Top