Period Formating (Office 97)

Topic

New Reply

Hi
Ref post 261093

Hans V kindly showed me how format numbers in which in needed to include periods, I now have the reverse in another spreadsheet, I need to take out the periods

ie K30.03.300 to K3003300 can anyone help please.

Regards

Braddy

Reply | Quote

Replies

Use the Substitute() function

=SUBSTITUTE(C12,”.”,””)

HTH

Peter

Reply | Quote

Hi Peter

Thanks very much that was a big help.

Regards

Braddy

Reply | Quote