Notadumbblonde
Board Regular
- Joined
- Nov 18, 2003
- Messages
- 104
Hey Excels, Got a interesting problem.
I have a spreadsheet that all my staff keys into
I constantly do range value (sorry Lotus Term) copy special value, and then format the numbers.
Is there any way I can code:
1. To make the range I'm extracting numbers!! if currently Strings
2. Make them a predefined format, say 1 decimal point.
Any Help would greatly be appreciated.
I make use conditional formatting, but my users may be cutting and pasting from text files.
I have a spreadsheet that all my staff keys into
I constantly do range value (sorry Lotus Term) copy special value, and then format the numbers.
Is there any way I can code:
1. To make the range I'm extracting numbers!! if currently Strings
2. Make them a predefined format, say 1 decimal point.
Any Help would greatly be appreciated.
I make use conditional formatting, but my users may be cutting and pasting from text files.