Text vs Number

B

Beege

Hi all,

Been lurking alot, trying to keep up on Excel skills.

Please - why do people insist on using number format if they are never going
to use the number in a calculation? Why not as a rule format things like zip
codes and serial numbers as text? Bringing me to my next question, which is
Does Excel have text "masking" as Access does? In other words, if text input
is A123456, how then can it be displayed as A-12345.6?

I don't have a specific issue, just curious.

Beege
 
D

Dave Peterson

'Cause it's easier to just start typing???

And no, excel doesn't support this kind of mask. In fact, number formatting
only applies to numbers--not text.

Although, you could use an extra column with a formula to format it the way you
like--or a worksheet event to do the work for you.
 
Top