Thread: retain value and delete format
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
  
Posts: 622
Default retain value and delete format
Let's start over.

Where did this data come from? Why is there a formatting issue? Check
carefully, are there any Spaces after the numbers in those cells?

Have you tried this:
Edit menu:Clear:Formats
Reply With QuoteReply With Quote