Question on Formatting numbers

R

rukhl

New Member
Joined
Feb 12, 2005
Messages
3
Hi

I'm trying to in put zip codes that start with a 0, but whenever I do the 0 disappears. Is there anyway to change the format so the 0 is included?
thanks,
Rachel
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
green triangle in corner

Thanks, both work. When I went back and added the zeros a small green triangle appeared in the corner. Is there a way to get rid of that?
 
Upvote 0
i would recommend using the format as Zip Code.. the green triangle is telling you a number stored as text..

you can click on the green triangle and tell it to ignore error..

however if you ever want to perform a lookup function then it will not work with numbers stored as text
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Numbers in Cells
Replies
6
Views
288
Joe4
Joe4
R
  • Solved
Custom Chart template when using slicer
Replies
2
Views
131
RodneyW
R
R
  • Question
Three-lane Stopwatch?
Replies
7
Views
166
RaymondW
R
C
  • Question
Microsoft Advanced Filter works only intermittently. Same exact filter in another workbook with same exact layout doesn't work.
Replies
2
Views
187
c_bro2498
C
O
  • Question
Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.
Replies
6
Views
1K
nemmi69
nemmi69

Forum statistics

Threads
1,215,044
Messages
6,122,827
Members
449,096
Latest member
Erald

Share this page

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
Back
Top