Numeral defaults to "0" at the 16th character space in a cell

  • Thread starter Thread starter Clint
  • Start date Start date
C

Clint

I cannot input any numeral other than a 0 after the 16
character space within a cell. For example; if I want to
type in a number 5 on the 16th space in a cell, it
automatically changes to 0. This is very frustrating, can
anyone help me?
 
Hi Clint
Have you tried
Format/Cells/Number
and then increase your Decimal Places to what you require.
Regards
Michael
 
Hi Clint!

Format as Text because Excel doesn't work beyond the fifteen
significant figures. Any digits beyond 15 will change to zeros

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
excel only supports 15 significant digits.

If you don't need the entry to be numeric, format the cell as text then type
your data or just precede your data with an apostrophe.

'1234124312341234

The value will be text.
 
Back
Top