Hi,
I'm putting a data base together that needs to keep the zeros before a number 00001,00002, etc.
When I input it excel removes the zeros. How can I stop it doing that?
Mike
Hi,
I'm putting a data base together that needs to keep the zeros before a number 00001,00002, etc.
When I input it excel removes the zeros. How can I stop it doing that?
Mike
Last edited by MikeJ1962; 01-14-2013 at 11:56 AM. Reason: Solved!
One way is to format the cells as text.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Highlight your range. Right cilck>format cells>>text>>ok.
Problem solved!
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks