Excel Converting number incorrectly

[Mister H]

Hi:

I am working on a spreadsheet and when I type in a long number Excel is converting the number. I try keying:

123123456123412345612345612341234

Excel populates the cell with: 1.23123456123412E+32 or futher shortens that to 1.23E+32

Can this feature be turned off. I am trying to get a range of cells to format that number as:

123-123456-1234-123456-123456-1234-1234

I have a code that was supplied to me but as mentioned above Excel is changing my number. I do not want to have to key ' before each number.

Thanks,
Mark

 

[tusharm]

A more extended discussion on the same subject is at http://www.mrexcel.com/board2/viewtopic.php?t=176216