GiannisWifey
Posted:
Member since
EXCEL HELP!
when I go to enter a zipcode, for example 01234, it omits the 0 and just shows 1234.
Does anyone know how to disable the feature so I can put the 0 in without it being eliminate?
Jna2010
Posted:
Member since
Re: EXCEL HELP!
right click format cells, number tab, select text option
eta lemme guess your doing your csv file
GiannisWifey
Posted:
Member since
Re: EXCEL HELP!
noooooooooooo csv....i did that a while agoooooooooooo
![]()
![]()
mosh424
Posted:
Member since
Re: EXCEL HELP!
what excel do you have?
i know how to do it i just need to explain it
nevermind
Jna2010
Posted:
Member since
GiannisWifey
Posted:
Member since
runnerbride1023
Posted:
Member since
Re: EXCEL HELP!
put an apostrophe in front of the number
Jna2010
Posted:
Member since
Re: EXCEL HELP!
Posted by GiannisWifey
Posted by Jna2010
holy moly!!! haroulas on the balllllllll ![]()
![]()
![]()
![]()
![]()
im kidding - yes its the csv file ![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Kiki1103
Posted:
Member since
Re: EXCEL HELP!
Posted by RAK220
put an apostrophe in front of the number
yep that will work
Soon2BNavi
Posted:
Member since
Re: EXCEL HELP!
you can format the cell to be a zip code and it will leave the 0
Format -->cells --> special --> zip code
HTH
