Text vs Number

  • Thread starter Thread starter Beege
  • Start date Start date
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
 
'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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/Match with text-looking numbers 1
Duff Date Text 3
Text vs. Number 5
Select cells with text 4
Format Questions 4
Excel Change Excel Text colour from Formula Bar 0
Can't Explain N/A in Vlookup 2
Numbers better as Text? 7

Back
Top