is there a way "around" this? i have six million numbers to enter and it is
just so much easier to enter as a format.

"Peo Sjoblom" wrote:

I assume you mean custom format as opposed to formula, regardless Excel
truncates all numbers after 15 digits that is why you get 1470 in the end
Excel has 15 digits precision so you cannot use custom formatting and
numbers to display this, you need to enter the lot as text without any
formatting


--
Regards,

Peo Sjoblom



"AccentStripe" wrote in message
...
it doesnt work. entered formula 0000"/"0000 "TO" 0000"/"0000. entered
"1786000018451476". displays as 1786/0000 to 1845/1470. excel is
rounding
and i dont want it to.