Thread: how to delete the 4 rightmost digits from a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
macropod
 
Posts: n/a
Default how to delete the 4 rightmost digits from a cell
Hi charlene,

For a value in A1,
=INT(A1/10000)
deletes the 4 right digits.

Cheers

--
macropod
[MVP - Microsoft Word]


"charlene" wrote in message
...
is it possible to delete the 4 rightmost digit of a cell ?


Reply With QuoteReply With Quote