Excel 2007 is changing my numbers.

Hi Matt

The reason why this is happening is that Microsoft Excel thinks what you are entering is a time value. Is this what you are planning to enter this as?

If not, you can add an apostrophe at the front of your text so that it formats it correctly to what you are wanting to display it as.

='00:00:00.031

Hope this helps.

Cheers,

Hi Matt - In experimenting with the FORMAT >>> CELLS >>> CUSTOM, I could not get the ##:##:##.### edit mask to work.

However, what Steven shared might work for you particularly if you have several of these to cut/paste into a column.

If you put a single quote in front of these, they'll paste in fine (which is how you can trick Excel from autoformatting some fields).

Please Login or Register  to view this content.

This might work for you:

1. Open Notepad

1. Take the raw data for 00:00:00.031 and copy it all to notepad

2. Then in notepad you can insert the single quote in front of each value down the list

3. You can then paste all cells from Notepad directly into Excel

Some of our more experienced members might have a better way, as I'm still a learner myself