Zero drops at the end of a number

Ms Bee

New Member
Joined
Oct 6, 2006
Messages
1
I upload a list of reference numbers from a website into an excel spreadsheet. If this number has a zero at the end of it, excel will drop it. For example if the number should read 4445550, excel will show 444555. My reference numbers are both 4445550 and 444555 so I can't assume that a zero should be placed there. If I save this file from the website into a text file the number will show correctly.

Is there a way to format the cells so that it shows all the characters given?

Thank you for your help!!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
Hi -

Welcome to the board.
the question is, how would you upload the file? is it using web query or something? would it be possible to provide the link to the site you're talking about?
 

Forum statistics

Threads
1,141,158
Messages
5,704,636
Members
421,360
Latest member
Rhodia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top