• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

Trying to enter MAC address

I'm trying enter some MAC addresses on a Excel spreadsheet, however when I enter certain MAC addresses, excel turns it into an equation, (ex. 001280938E92), I noticed that any MAC address with the letter 'E' followed by a number, excel changes it, (1.28E+98) that's what Excel changed it to after I typed in the MAC address. Is there any way I can stop it from doing that? I've tried formatting cells and clicking on General, but it keeps changing it back. All the other MAC addresses I've been able to enter with no problem, just the ones with the letter 'E' followed by a number are giving me problems
0
GRaw
Asked:
GRaw
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
Hi,
When you enter the mac address, start typing with a single quote - '.

this is preserve your formatting in excel. So instead of 001280938E92, try it as '001280938E92.
0
 
Rory ArchibaldCommented:
Or format the cells as Text before entering your data.
0
 
GRawAuthor Commented:
That worked!! Thanks, it was driving me crazy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now