Thread: Removing a leading space in a numbered currency cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Removing a leading space in a numbered currency cell
Hi, Try this:
Select all data cells and change format to General.
Put a zero into a cell, select it, then Copy.
Select all data cells.
Paste special, Add
OK

Regards - Dave.
Reply With QuoteReply With Quote