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
Results 1 to 3 of 3
Thread: Period Formating (Office 97)
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-07-07 10:27Period Formating (Office 97)
If you are a fool at forty, you will always be a fool
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
3 Star Lounger
- Join Date
- Jun 2001
- Location
- Maidstone, Kent, England
- Posts
- 398
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-07-07 10:50Re: Period Formating (Office 97)
Use the Substitute() function
=SUBSTITUTE(C12,".","")
HTH
Peter
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2003-07-07 10:58Re: Period Formating (Office 97)
Hi Peter
Thanks very much that was a big help.
Regards
BraddyIf you are a fool at forty, you will always be a fool
