Thread: edit a record like 17.00 gbp so it becomes 17.00 using a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default edit a record like 17.00 gbp so it becomes 17.00 using a formula
Hi John,
assuming your first one is in A2, =VALUE(LEFT(A2,LEN(A2)-4)) in row 2
of any other column could be filled down to produce a column of number
values.
I'm also assuming that it is a single space between the number and the
g.

Ken Johnson

Reply With QuoteReply With Quote