Thread: Cells drop leading zeros from numbers
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default Cells drop leading zeros from numbers
0555AA is text data, not numeric.

Excel would treat as text and not drop the 0


Gord Dibben MS Excel MVP

On Mon, 11 Apr 2011 18:51:57 -0700 (PDT), SQLUser wrote:

The 0000000# works a number, but if the original value is 0555AA.
Then placed into EXCEL, the value goes to 555AA.
Reply With QuoteReply With Quote