• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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