Thread: Masking numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj
 
Posts: n/a
Default Masking numbers

If you need it to be a number try
=value(right(A1,4))
if it can be text don't use the value()

"RNeducator" wrote:

I need to remove or hide the first 5 digits in a string of 9 numbers for a
column. Any easy way to do this?