Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 05-2117

Excel autoformats a cell when I input the string of characters 05-2117. Has
anyone had a problem with this before? This is a customer number I am
inputing into a spreadsheet, but no matter what I format the field to be
Excel always changes the field to either be Date, the data gets changed to
May-71, or if I force the formatting to either General or Number the data
gets changed to 79380.

I've tried this on 2 different versions of MS Office, Office 2000 Pro and
Office 2007 Pro, and get the same results from both products. Has anyone come
across this before?

Is 05-2117 some kind of internal code that Excel uses and I just can not
input that string of data into any fields at all?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"